Re: How to use right/left Join in DELETE/UPDATE

[Bob Field]

In the list of tables from which rows are to be deleted, if you have provided aliases for table names, then you must use those aliases and not the actual table name.

DELETE b
FROM tmpptabled AS a
RIGHT JOIN salesd AS b ON a.book = b.book AND a.vrno = b.vrno AND a.srno = b.srno
JOIN salem AS c ON b.book = c.book AND b.vrno = c.vrno
WHERE a.vrno is null