How do I edit this script to make sure it is only pulling active MBR's?
select Name=3Dsa.firstname +' '+ sa.lastname, Login
from subaccounts sa, masteraccounts ma
where sa.customerid =3D ma.customerid
and ma.zip=3D'12345'
Thanks,
John
*********** REPLY SEPARATOR ***********
On 4/11/2000 at 10:13 AM Josh Hillman wrote:
>From: PowerNet <psc5@powersupply.net>
>>I am looking for a script that will list my usernames by zip code.
>>I would like to put in the zip code and then find & list all user names=
by
>zip
>
>select Name=3Dsa.firstname +' '+ sa.lastname, Login
>from subaccounts sa, masteraccounts ma
>where sa.customerid =3D ma.customerid
>and ma.zip=3D'12345'
>
>
>Josh
>
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart