How to use right/left Join in DELETE/UPDATE

[Iresh Patel]

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.