dimanche 24 juillet 2016

Mysql Delete Query from tow table

Hello I Have write Delete Query

delete installments . InstallmentID , Installment_part . InstallmentID  , Installment_part.Parts_ID ,Installment_part.*  FROM installments
    INNER JOIN
Installment_part ON installments.InstallmentID = Installment_part.InstallmentID 
WHERE
(((installments.InstallmentID) = 7)
AND ((Installment_part.InstallmentID) = 7));

It Give me this Error Unknown Table InstallmentID i have change it to Select Statement and it show me what i want to Delete

Aucun commentaire:

Enregistrer un commentaire