Anyone knows who to make exclusion query when table is referenced via JOIN:
SELECT * FROM ae_articles AS art LEFT JOIN ae_articlesections AS sec ON art.ID=sec.articleID LEFT JOIN ae_articlesections AS sec2 ON art.ID=sec2.articleID LEFT JOIN ae_articlesections AS sec3 ON art.ID=sec3.articleID WHERE 1 AND (art.title LIKE '%bush%') AND sec.sectionID='1' AND sec2.sectionID='2' AND sec3.sectionID<>'3' GROUP BY art.ID
This returns all articles, even those that are in section ID 3. I only want to retrieve those that are in section 1 AND 2, but NOT 3! How to do this?
I am absolutely stuck not knowing what to do, since MySQL does not provide any examples!
Thank you,
Daniel
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
