Add "and ma.active=1" to it. I included it below. If you wanted it based
on expiration date, you would add "and ma.maexpiredate >= '4/1/00'"
(changing the date to whatever you wanted)
select Name=sa.firstname +' '+ sa.lastname, Login
from subaccounts sa, masteraccounts ma
where sa.customerid = ma.customerid
and ma.zip='12345'
and ma.active = 1
Josh
*********** 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=sa.firstname +' '+ sa.lastname, Login
>from subaccounts sa, masteraccounts ma
>where sa.customerid = ma.customerid
>and ma.zip='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
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart