Ïîíåäåëüíèê, 12 Ôåâðàëÿ 2018 ã. 15:37
+ â öèòàòíèê
×òî ìîæåò îçíà÷àòü ïîäîáíûé ñèíòàêñèñ â Access?
DELETE SubMasterlist.*,Partlist.LotID
FROM Partlist
INNER JOIN SubMasterlist ON Partlist.PLID = SubMasterlist.PLID
WHERE Partlist.LotID = ...
Èíòóèòèâíî ÿ áû ñêàçàë, ÷òî óäàëåíèå äîëæíî ïðîèñõîäèòü èç òàáëèöû Partlist, à ñïèñîê ïîëåé "SubMasterlist.*,Partlist.LotID " íå èìååò çíà÷åíèÿ è åãî âîîáùå ìîæíî óáðàòü..
Íî çàñîìíåâàëñÿ, âäðóã â Access ýòî ìîæåò îçíà÷àòü ÷òî-òî äðóãîå? íàïðèìåð óäàëåíèå èç îáåèõ òàáëèö?
http://www.sql.ru/forum/1285112/sinatksis-delete
-
Çàïèñü ïîíðàâèëàñü
-
0
Ïðîöèòèðîâàëè
-
0
Ñîõðàíèëè
-