MySQL Forums
Forum List  »  Microsoft SQL Server

How to use right/left Join in DELETE/UPDATE
Posted by: Iresh Patel
Date: June 29, 2006 01:39AM

How to use join in DELETE/UPDATE SYNTEX.

i have 3 table. SALESM header part, SALESD detail part and
TMPTABLED is my temporary detail table where data is deleted (2-3 rows
only). Now i want to update the SALESD table. i m migrating from MSSQL to mySql. for the same my MSSQL SERVER
syntex is given below and it is working fine. But how to do the same in mySql.
Can anyone suggest me ?

MSSQLSERVER SYNTEX
delete salesd from tmpptabled a
right outer join salesd b on a.book=b.book and a.vrno=b.vrno and a.srno=b.srno
join salem c on b.book=c.book and b.vrno=c.vrno
where a.vrno is null



Edited 2 time(s). Last edit at 06/29/2006 01:41AM by Iresh Patel.

Options: ReplyQuote


Subject
Written By
Posted
How to use right/left Join in DELETE/UPDATE
June 29, 2006 01:39AM


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.