Re: Consolidation

Dale E. Reed Jr. ( (no email) )
Thu, 27 Aug 1998 17:30:52 -0700

greg Lowthian wrote:
>
> I ran this and it returned 0 Rows affected
>
> 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

Then you should be ok. The summary is only a summary an not exactly.

-- 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