RE: Consolidation

Greg Lowthian ( (no email) )
Wed, 26 Aug 1998 08:08:55 -0700

Is this query correct. How would I delete all orphaned call
records.

> You can
> run a query like this to see what records are in your
> calls table
> that don't have a user match:
>
> Select Username, Calls=Count(*)
> From Calls
> Where Username NOT IN
> (Select Login From SubAccounts UNION
> Select EMail From SubAccounts)
> Group By UserName
> Order By UserName
>
>
> An example of this would be the new "admin" login from a PM3.
>
> --
> Dale E. Reed Jr. (daler@iea-software.com)
> _______________________________________________________
> __________
> IEA Software, Inc. | RadiusNT, Emerald,
> and NT FAQs
> Internet Solutions for Today | http://www.iea-software.com
>