Re: [Emerald] SQL Question

Dale E. Reed Jr. ( (no email) )
Fri, 05 Nov 1999 11:53:12 -0800

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Dale E. Reed Jr.: "Re: [Emerald] VSA and USR's"
Next message: Richard Sensale: "[Emerald] Looking for report"
Maybe in reply to: talon : "[Emerald] SQL Question"

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

Previous message: Dale E. Reed Jr.: "Re: [Emerald] VSA and USR's"
Next message: Richard Sensale: "[Emerald] Looking for report"
Maybe in reply to: talon : "[Emerald] SQL Question"