Sorry there was an error in the first one I sent
Try this one
USE AbacBill
SELECT Emails.EmailAddress
FROM Emails,
Plans,
Customers
WHERE Emails.PlanID = Plans.PlanID AND
Plans.Closed = 0 AND
Plans.CustomerID = Customers.CustomerID
Erik L. M. Tijburg
ISP Support Services
(214) 681-4976
[EMAIL PROTECTED]
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Darren
Sent: Wednesday, November 05, 2003 1:13 PM
To: [EMAIL PROTECTED]
Subject: [Rodopi] need help with a query
Hey all,
I'm trying to pull out a list of all the emails in our system.
I have this simple query:
SELECT *
FROM ObjectValues
WHERE Value_LPSTR LIKE '[EMAIL PROTECTED]' AND
ORDER BY ObjectID
I'm unsure how to filter out all the emails that are from closed plans?
I don't see how to join the "ObjectValues" table with the "Plans" table.
Any help is appreciated.
Thanks,
- Darren
---------------------
To Leave the Rodopi mail list send a message to [EMAIL PROTECTED]
with the word LEAVE as the message body.
Please also visit the Rodopi FAQ at http://www.rodopi-faq.com
---------------------
---------------------
To Leave the Rodopi mail list send a message to [EMAIL PROTECTED]
with the word LEAVE as the message body.
Please also visit the Rodopi FAQ at http://www.rodopi-faq.com
---------------------
