Re: Structural and Conceptual dillemma with multiple word FTSearch on multiple tables

[Rick James]

Give this a try:

SELECT man_id
   FROM
      ( SELECT man_id FROM Manufacturer WHERE MATCH(name) AGAINST('+Apple') ) m
   JOIN
      ( SELECT man_id FROM Products WHERE MATCH(name) AGAINST('+Idud') ) p
   ON m.man_id = p.man_id;