Jump to content


Photo

mySQL: SELECT FROM TWO TABLES


  • Please log in to reply
1 reply to this topic

#1 friendly

friendly
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 06 November 2003 - 05:43 AM

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]

#2 Barand

Barand
  • Moderators
  • Sen . ( ile || sei )
  • 18,025 posts

Posted 06 November 2003 - 07:59 PM

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.
If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.

Donations gratefully received






moon.png

|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users