Hi, Sorry, I should have mentioned that we have Version: 5.2 sp3.
There is no "Emails" table. It looks like they are all stored in the "ObjectValues" table. - Darren On Wed, 2003-11-05 at 11:26, Erik Tijburg wrote: > 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 > --------------------- --------------------- 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 ---------------------
