Martin, that did the trick! Thanks a bunch!
- Darren On Wed, 2003-11-05 at 11:54, Martin wrote: > 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 > --------------------- --------------------- 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 ---------------------
