Re: [Emerald] Users who have called

Dale E. Reed Jr. ( (no email) )
Mon, 08 Mar 1999 22:12:14 -0800

"Robert H. Clugston" wrote:
>
> List,
> I want to print up a list of all the people who have called my PM3's in
> the past few months. Is this query look correct, because if so I'm showing
> that a lot of people aren't using my system.
>
> SELECT
> DISTINCT SubAccounts.LastName,
> SubAccounts.FirstName
> FROM
> emerald.dbo.Calls Calls INNER JOIN emerald.dbo.SubAccounts SubAccounts ON
> Calls.AccountID = SubAccounts.AccountID

This is only correct AFTER you have done a calls update in the
Emerald Admin. A better/faster query would be:

Select Username, count(*)