SQL query error ?!? Work with other database

[LinuXelite]

UPDATE (factures INNER JOIN factures_details ON factures.COMMANDE_R = factures_details.COMMANDE_L)
INNER JOIN dictionnaire_items_total ON (factures_details.NOCOMPAGNIE = dictionnaire_items_total.NOCOMPAGNIE)
AND (factures_details.ITEM_CODE = dictionnaire_items_total.ITEM_CODE)
AND (factures_details.LINE_CODE = dictionnaire_items_total.LINE_CODE)
SET factures.categorie = dictionnaire_items_total.categorie
WHERE (((factures.categorie)="&quot)
LIMIT 50;


Error:

Error: 1064 - You have an error in your SQL syntax near '(factures INNER JOIN factures_details ON factures.COMMANDE_R = factures_details.' at line 1


Any idea??? The same query works with others databases such as dbase.

 

[sleipnir214]

So far as I know, MySQL does not support updates across joins.

The summary of the syntax of the UPDATE command (

http://www.mysql.com/doc/en/UPDATE.html)

uses the phrase "tbl_name" to describe what you are updating. ______________________________________________________________________
TANSTAAFL!

 

[LinuXelite]

mysql 4 support it