Re: [Emerald] SQL Question

Dale E. Reed Jr. ( (no email) )
Wed, 10 Nov 1999 12:22:20 -0800

Nathan Haywood wrote:
>
> Shouldn't that be USERNAME in the CALLS table?
>
> How about...
>
> Select Username, NumCalls=count(*)
> into #tmp_users
> From Calls
> Group By Username
>
> Select Login
> From SubAccounts
> Where Login Not IN (Select Username From #tmp_users)
>
> Drop Table #tmp_users

Yep. :)

-- 

Dale E. Reed Jr.      Emerald and RadiusNT__________________________________________IEA Software, Inc.    www.iea-software.com

For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart