Re: [Emerald] Users who have called

Dale E. Reed Jr. ( (no email) )
Tue, 09 Mar 1999 22:26:23 -0800

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Dale E. Reed Jr.: "Re: [Emerald] Questions"
Next message: Dale E. Reed Jr.: "Re: [Emerald] printed invoices"
Maybe in reply to: Robert H. Clugston: "[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

Previous message: Dale E. Reed Jr.: "Re: [Emerald] Questions"
Next message: Dale E. Reed Jr.: "Re: [Emerald] printed invoices"
Maybe in reply to: Robert H. Clugston: "[Emerald] Users who have called"