mySQL: SELECT FROM TWO TABLES

[friendly]

I am doing a SELECT FROM function on one table, with a LEFT JOIN. I would like to do a MATCH AGAINST(table2.column).

 

I\'ve attached the code I\'ve been using below.

 

SELECT pmw_products.*, pmw_manufacturers.description AS manu_description FROM pmw_products LEFT JOIN pmw_manufacturers ON pmw_products.manufacturer=pmw_manufacturers.id, WHERE MATCH(manu_description) AGAINST(\'$search_string\')

 

Does anyone know if this is possible and how to do it.

 

Cheers[/img]

[Barand]

Performing

 

... pmw_products LEFT JOIN pmw_manufacturers ...

 

will give you all products with null in the manu_description field where a product has no manufacturer.

 

As you are selecting a particular value for manu_description, the LEFT JOIN is pointless, may as well do a normal INNER JOIN.