Re: [Emerald] Script

Josh Hillman ( (no email) )
Tue, 11 Apr 2000 10:13:33 -0400

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: PowerNet: "[Emerald] Script"
Next message: Josh Hillman: "Re: [Emerald] TimeOn page"
Maybe in reply to: PowerNet: "[Emerald] Script"
Next in thread: Josh Hillman: "Re: [Emerald] Script"

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

Previous message: PowerNet: "[Emerald] Script"
Next message: Josh Hillman: "Re: [Emerald] TimeOn page"
Maybe in reply to: PowerNet: "[Emerald] Script"
Next in thread: Josh Hillman: "Re: [Emerald] Script"