1

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?

2

Re: Syntax DELETE

The pancake, gathered it in a forum on Access.

3

Re: Syntax DELETE

Continue. It is interesting to us. About .
The moderator: the Subject is transferred from a forum "Simply idle talk".

4

Re: Syntax DELETE

Bill wrote:

That 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?

Small subtlety. At you tight coupling between the tables, one-to-one. And if in table SubMasterlist there is a correspondence for any element from table Partlist these records do not get to selection, though condition WHERE Partlist. LotID =... For them it can and be fulfilled.

5

Re: Syntax DELETE

Bill wrote:

That can mean similar syntax in Access?

In the given specific case removal of records from table SubMasterlist will be produced. Presence in the list of removal of single field Partlist. LotID it will be ignored.
If the removal list looked as SubMasterlist. *, Partlist. * or generally missed - records would be remote from both tables.
Actually the request text does not correspond to the built in documentation according to which the instructions of all fields in the removal list are admitted only. For what reason it is ignored, instead of leads Syntax Error - a riddle... But companions from M $ are not very accurate at all.

6

Re: Syntax DELETE

Joss wrote:

At you tight coupling between the tables, one-to-one.

Whence such inference? I in an emphasis do not see instructions that field PLID at least in any of tables unique.

7

Re: Syntax DELETE

However, if field Partlist. PLID was not unique - the request would not be fulfilled, there would be an error report (something of type "is impossible removal from the specified tables" - i.e. instructions on ambiguity of communication).