What Query would I use for all expired accounts?
Thanks,
John
*********** REPLY SEPARATOR ***********
On 2/26/00, at 1:10 PM, Nathan Haywood wrote:
>You mean, like...
>
>SELECT CustomerID, FirstName, LastName, Company, PhoneHome, PhoneWork
>FROM MasterAccounts
>WHERE maExpireDate IS NULL
>
>:-) Hope that helps...
>
>Nathan Haywood
>
>-----Original Message-----
>From: PowerNet [mailto:psc5@powersupply.net]
>Sent: Saturday, February 26, 2000 10:55 AM
>To: emerald@iea-software.com
>Subject: [Emerald] QUERY HELP!
>
>
>Can someone help me with a query to see what customers have with a blank
>expire date?
>
>Thanks,
>John
>
>
>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