UPDATE con JOIN non funzionante
Ciao a tutti,
non riesco a capire perchè questa query non funziona:
UPDATE sheets_features
JOIN products ON (products.id = sheets_features.product_id)
JOIN mdc_incisioni ON (products.n_inv = mdc_incisioni.`N. Inv.`)
SET sheets_features.descr_014 = mdc_incisioni.Nota
WHERE mdc_incisioni.Nota LIKE CONCAT(sheets_features.descr_014,'%') AND mdc_incisioni.Nota NOT LIKE sheets_features.descr_014
voglio aggiornare il campo di una tabella con i dati presenti in un'altra.
Mi sembra semplicissimo il risultato che mi da è "0 righe modificate" !
Grazie in anticipo!
Subject
Views
Written By
Posted
UPDATE con JOIN non funzionante
2565
April 03, 2012 10:22AM
1389
April 04, 2012 02:53AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.