[Rodopi] need help with a query

[Martin]

Darren,

Give this a shot:

Select ObjectValues.Value_LPSTR from Plans
inner join Objects on Plans.PlanId = Objects.PlanID
inner join ObjectValues on Objects.ObjectID = ObjectValues.ObjectID
WHERE ObjectValues.Value_LPSTR LIKE '[EMAIL PROTECTED]'
AND Plans.Closed != 1
Darren wrote:

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
---------------------