DELETE SubMasterlist.*,Partlist.LotID FROM Partlist INNER JOIN SubMasterlist ON Partlist.PLID = SubMasterlist.PLID WHERE Partlist.LotID = ...
http://www.sql.ru/forum/1285112/sinatksis-delete