Re: [Emerald] SQL Question

Dale E. Reed Jr. ( (no email) )
Fri, 05 Nov 1999 11:53:12 -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??

There is an active flag on both the MasterAccounts and SubAccounts
tables. Either set makes the service NON-active:

Select ma.CustomerID, sa.AccountID, sa.Login