Re: simple update script

Dale E. Reed Jr. ( (no email) )
Tue, 18 Mar 1997 15:25:02 -0800

Jim Dornbush wrote:
>
> I do something similar to get the e-mail addresses, change the SQL to this:
> Select sa.email FROM subaccounts.sa, masteraccounts.sa WHERE sa.active=1
> and ma.active=1

AND ma.CustomerID = sa.CustomerID

If you leave that off, you'll get a LOT of results. :)

-- Dale E. Reed Jr.  (daler@iea.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |    http://www.emerald.iea.com