update com inner join

[diokhan]

boas,

como posso fazer um update com condiçoes inner join? eu tenho assim, mas não funciona:

$stmt = $this->dbh->prepare("UPDATE QUALITY Q
  SET Q.RAW_WELLS = :rawWells, Q.TOTAL_KEYPASS = :totalKeyPass, 
  Q.KEYPASS = :keyPass, Q.DOT_FAILED = :dotFailed, 
  Q.MIXED_FAILED = :mixedFailed, Q.SHORT_QUALITY = :shortQuality, 
  Q.PRIMER_FAILED = :primerFailed, Q.PASSED_FILTER = :passedFilter, 
  Q.CONTROL_LIBRARY = :controlLibrary
  Inner Join QUALITY_PROJECT AS QP ON QP.ID_QUALITY = Q.ID_QUALITY
  Inner Join PROJECT AS P ON QP.ID_PROJECT = P.ID_PROJECT
  WHERE Q.REGION = :region AND Q.CONTROL_LIBRARY LIKE :controlLibrary2 
  AND QP.ID_PROJECT = :idProject");
$stmt->bindParam(':rawWells', $data['totalRawWells']);
$stmt->bindParam(':totalKeyPass', $data['numKeyPass']);
$stmt->bindParam(':keyPass', $data['totalKeyPass']);
$stmt->bindParam(':dotFailed', $data['numDotFailed']);
$stmt->bindParam(':mixedFailed', $data['numMixedFailed']);
$stmt->bindParam(':shortQuality', $data['numTrimmedTooShortQuality']);
$stmt->bindParam(':primerFailed', $data['numTrimmedTooShortPrimer']);
$stmt->bindParam(':passedFilter', $data['totalPassedFiltering']);
$stmt->bindParam(':controlLibrary',$data['keySequence']);
$stmt->bindParam(':region', $data['name']);
$stmt->bindParam(':controlLibrary2', $keySeq2);
$stmt->bindParam(':idProject', $idProject);
$stmt->execute();

alguem pode ajudar-me ou a explicar-me como isto funciona? ?

[ByMySlf]

Vê se isto te ajuda: Cross Table Update

[M6]

Falta-te o FROM.

Vê a sintaxe na documentação.

[diokhan]

obrigado pelas dicas, já ficou resolvido 😛