Hi Daniel,
> Jigal, thank you very much. However, this does not resolve my issue.
>
> even when querying:
> SELECT * FROM ae_articles AS art LEFT JOIN ae_articlesections AS sec ON
> art.ID=sec.articleID WHERE art.title LIKE '%bush%' AND sec.sectionID IN
(1,2)
> AND sec.sectionID NOT IN (3)
What *
Your query can be made a lot simpler if I understand your description:
SELECT * FROM ae_articles AS art
JOIN ae_articlesections AS sec ON art.ID=sec.articleID
WHERE art.title LIKE '%bush%' AND sec.sectionID IN (1,2)
This has nothing to do with MySQL, but is a matter of knowing SQL syntax.
You can
