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