CODEWITHSUNDEEP
mysql
FranCode
FranCode

Reputation: 113

What's wrong with that query?

When I run this query I got syntax error. Why?

UPDATE `p` SET `p`.`PIVA` = `i`.`CCT_CODICE_PI`, `p`.`CODICE_FISCALE` = `i`.`CCT_CF`
FROM `CONTATTI_T_Contab_Progetti_Finale` `p`
LEFT JOIN `CONTATTI_T_Contab_Anagrafica` `i` ON `p`.`CCK_ANAGRAFICA` = `i`.`CCK_ANAGRAFICA`
WHERE `p`.`DAK_ANES_COGE` < 2014

Upvotes: 0

Views: 40

Answers (1)

Fahmi
Fahmi

Reputation: 37483

You can try below - update syntax is different for MYSql

UPDATE `CONTATTI_T_Contab_Progetti_Finale` `p`
LEFT JOIN `CONTATTI_T_Contab_Anagrafica` `i` ON `p`.`CCK_ANAGRAFICA` = `i`.`CCK_ANAGRAFICA`
SET `p`.`PIVA` = `i`.`CCT_CODICE_PI`, `p`.`CODICE_FISCALE` = `i`.`CCT_CF`
WHERE `p`.`DAK_ANES_COGE` < 2014

Upvotes: 2

Related Questions