-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.
Sent: Tuesday, March 09, 1999 10:26 PM
To: emerald@iea-software.com
Subject: Re: [Emerald] Users who have called
"Robert H. Clugston" wrote:
>
> Close but I what names and a number where I can call them at. I'm
going to
> be calling users to have them change their access number.
Select DISTINCT c.Username, sa.FirstName, sa.LastName, sa.WorkPhone,
sa.HomePhone
From Calls c, SubAccounts, sa
Where NASIdentifier='x.x.x.x'
and c.Username = sa.Login
--Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list, including removal,please see http://www.iea-software.com/maillist.html
For more information about this list, including removal,please see http://www.iea-software.com/maillist.html