Re: [Emerald] SQL Question
Dale E. Reed Jr. ( (no email) )
Wed, 10 Nov 1999 11:11:10 -0800
talon wrote:
>
> to my understanding the username and active cells are not in the
> same table. What is the best way to query and get a list of
> NON-active users and there user names??
I would create a work table to summarize the calls table, then
compare against it:
Select Login, count(*)
into #tmp_users