-Ïîèñê ïî äíåâíèêó

Ïîèñê ñîîáùåíèé â rss_sql_ru_access_programming

 -Ïîäïèñêà ïî e-mail

 

 -Ïîñòîÿííûå ÷èòàòåëè

 -Ñòàòèñòèêà

Ñòàòèñòèêà LiveInternet.ru: ïîêàçàíî êîëè÷åñòâî õèòîâ è ïîñåòèòåëåé
Ñîçäàí: 16.03.2006
Çàïèñåé:
Êîììåíòàðèåâ:
Íàïèñàíî: 4


Ñèíàòêñèñ DELETE

Ïîíåäåëüíèê, 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


 

Äîáàâèòü êîììåíòàðèé:
Òåêñò êîììåíòàðèÿ: ñìàéëèêè

Ïðîâåðêà îðôîãðàôèè: (íàéòè îøèáêè)

Ïðèêðåïèòü êàðòèíêó:

 Ïåðåâîäèòü URL â ññûëêó
 Ïîäïèñàòüñÿ íà êîììåíòàðèè
 Ïîäïèñàòü êàðòèíêó