[EMAIL PROTECTED] ("Daren Cotter") wrote: >I am having major troubles creating this query...ok here's some >background info: > >I have three tables: members, which contains info about the member, such >as city, state, zip, marital status, etc; interests, which stores just >an interest_id and name; and member_interests, which stores just >member_id and interest_id. > >What I need to do is create a query that selects certain members from >the DB depending on certain demographics. For example, the query might >need to select all members from the DB where their country is USA, >Marital Status is Single, and have "Golf" selected as an interest. The >first two are no problem...but, is there any way to create ONE query >that would validate all the info stored in members table, as well as the >member_interests table? And if not, can someone provide a sample >solution method?
Yes, double inner join ..... Assuming people is the first table, links sits in the middle, and categories is a list of interests ...... SELECT People.FirstName, People.LastName, People.MaritalStatus, People.MobilePhone, Categories.CategoryName FROM (People INNER JOIN links ON People.AddressID = links.persid) INNER JOIN Categories ON links.catid = Categories.CategoryID; Rgds Denis -- Denis McMahon / +44 7802 468949 / [EMAIL PROTECTED] sulfnbk is not a virus, see the symantec virus encyclopaedia! Now restocking killfile, new entrants welcome: trolls, spam, xpost cascades, OT ads, top posters & terminally clueless! --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php