UPDATE INNER JOIN and ORDER BY
Posted by:
ENC ENC
Date: July 19, 2005 12:48PM
Can you tell me whats wrong with this SQL Query?
UPDATE Invoices INNER JOIN Customers ON Customers.atoCustomerKey=Invoices.idCustomer LEFT JOIN Jobs ON Jobs.idInvoice=Invoices.atoInvoiceKey SET szCSR='Sung', szReferral='Kyle', szJobType='Repair', bImportantData=1, bRush=0, bRequireDeletion=0, bWarranty=0 WHERE atoInvoiceKey=0 AND atoJobKey=6 ORDER BY atoJobKey LIMIT 1
Subject
Written By
Posted
UPDATE INNER JOIN and ORDER BY
July 19, 2005 12:48PM
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.