Relevance searching across multiple tables

[bhotschins]

I've joined several columns from several tables, and I would like to
perform a relevance match against these multiple columns.

It looks something like this:

SELECT * FROM table1 LEFT JOIN table2 ON table1.column1 = table2.column1
WHERE
MATCH
(
table1.column4, table2.column2)
AGAINST ('%test%')

However, I am getting an error message stating #1210 - Wrong arguments
to MATCH

It works absolutely fine when i am working with one table, and works aboslutely
fine with "LIKE" but isn't working with multiple tables like above with "MATCH".


If you have any suggestions,
please let me know.

Thanks.