I am using this statement to update some tables:
UPDATE firme_ro
INNER JOIN z_icap_minim ON firme_ro.CUI=z_icap_minim.CUI
INNER JOIN firme_ro ON z_icap_minim.judet_Id <> firme_ro.judeteSiruta_Id AND z_icap_minim.cui = firme_ro.cui
SET firme_ro.Adresa=z_icap_minim.Adresa
WHERE firme_ro.StariFirme_Id=1
It gives error :#1066 - Not unique table/alias: 'firme_ro'
Any advices to make this work?