MySQL Forums
Forum List  »  Italian

UPDATE con JOIN non funzionante
Posted by: Alessio Stefanetti
Date: April 03, 2012 10:22AM

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!

Options: ReplyQuote


Subject
Views
Written By
Posted
UPDATE con JOIN non funzionante
2410
April 03, 2012 10:22AM


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.