Re: Fulltext search across two tables

[Oscar Preis]

Hi Felix,

I added the suggesstion but know I don't get any rows back although there is a user last name and company name that should match.
Here is the sql

SELECT a.fname, a.lname, a.phone, b.comp_name
FROM users as a, accounts as b
INNER JOIN accounts ON a.company_id = accounts.resource_id
WHERE MATCH (a.fname, a.lname) AGAINST ('john' IN BOOLEAN MODE)
AND MATCH(b.comp_name) AGAINST ('john' IN BOOLEAN MODE)