Re: FULL-TEXT SEARCH over Two Tables with JOIN?

[Rick James]

Since this is the FULLTEXT forum, use FULLTEXT syntax:

SELECT  a.artist, t.title, t.episode
    FROM  tracks AS t
    INNER JOIN  artist AS a ON a.id = t.artist
    WHERE  MATCH(a.artist) AGAINST ('+Spears' IN BOOLEAN MODE)
      AND  MATCH(t.title) AGAINST ('+World' IN BOOLEAN MODE);

Does that do what you want?