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