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