[Emerald] Users who have called

Robert H. Clugston ( (no email) )
Mon, 8 Mar 1999 17:11:20 -0800

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
============================================================================
Robert H. Clugston
E-mail:robert@comstocknet.com
Systems Administrator
Comstock Net, www.comstocknet.com
Phone: (909)877-6407
============================================================================

For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html