Topic: Syntax DELETE
What can mean similar syntax in Access?
DELETE SubMasterlist. *, Partlist. LotID FROM Partlist INNER JOIN SubMasterlist ON Partlist. PLID = SubMasterlist. PLID WHERE Partlist. LotID =...
Intuitively I would tell that removal should happen from table Partlist, and the list of fields "SubMasterlist. *, Partlist. LotID" has no value and it generally can be removed.
But began to doubt, suddenly in Access it can mean something another? For example removal from both tables?