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

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

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

 

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

 -Ñòàòèñòèêà

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


Ñãðóïïèðîâàòü ïî êëþ÷ó ðåçóëüòàòû íåñêîëüêèõ îäíîòèïíûõ SQL-çàïðîñîâ

Âòîðíèê, 30 Àïðåëÿ 2019 ã. 07:02 + â öèòàòíèê
Äîáðûé äåíü!
Èìåþ 3 îäíîòèïíûõ çàïðîñà è õî÷ó, ãðóáî ãîâîðÿ, îáúåäèíèòü èõ â îäèí åäèíûé çàïðîñ.

SELECT BY ID_m, prm1, prm2, prm3 
FROM table0
GROUP BY ID_m;


SELECT BY ID_m, A1, A2, A3 
FROM table1
GROUP BY ID_m;


SELECT BY ID_m, B1, B2, B3 
FROM table2
GROUP BY ID_m;


Êîíå÷íàÿ öåëü ïîëó÷èòü òàáëèöó:
ID_m, A1, A2, A3,B1, B2, B3, prm1, prm2, prm3

Ïîäñêàæèòå, ïîæàëóéñòà, êàê â äàííîì ñëó÷àå ïîñòóïèòü ïðàâèëüíåé?

https://www.sql.ru/forum/1312050/sgruppirovat-po-kluchu-rezultaty-neskolkih-odnotipnyh-sql-zaprosov


 

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

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

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

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