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

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

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

 

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

 -Ñòàòèñòèêà

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


Îäíèì çàïðîñîì îáúåäèíèòü äâå òàáëèöû è íàéòè ïîâòîðíûå çíà÷åíèÿ ïî ïîëþ

Ïîíåäåëüíèê, 20 Ìàðòà 2017 ã. 12:53 + â öèòàòíèê
Çäðàâñòâóéòå. Íåîáõîäèìî îäíèì çàïðîñîì îáúåäèíèòü äâå òàáëèöû è íàéòè ïîâòîðíûå çíà÷åíèÿ ïî ïîëþ, íà âûõîäå îòîáðàçèòü âñå ïîâòîðíûå çíà÷åíèÿ. ß ñäåëàë íàîáîðîò, ÷òî èùåò ïî äâóì òàáëèöàì ïîâòîðíûå çíà÷åíèÿ, à ïîòîì îòîáðàæàåò èõ. Íå ìîãó ïîíÿòü êàê ðåàëèçîâàòü ïî ïîñòàâëåííîé çàäà÷å?

Âîò ÷òî ðåàëèçîâàë
SELECT Ðàáîòíèêè.[ÔÈÎ áåçðàáîòíîãî],
 Ðàáîòíèêè.[Íàçâàíèå ïðåäïðèÿòèÿ] 
FROM Ðàáîòíèêè
WHERE (((Ðàáîòíèêè.[ÔÈÎ áåçðàáîòíîãî])
 IN (SELECT [ÔÈÎ áåçðàáîòíîãî] FROM [Ðàáîòíèêè] AS Tmp
 GROUP BY [ÔÈÎ áåçðàáîòíîãî]
 HAVING COUNT(*)>1 )))
ORDER BY Ðàáîòíèêè.[ÔÈÎ áåçðàáîòíîãî] 
 
UNION 
SELECT [Ðàáîòíèêè (îáðàçîâàíèå)].[ÔÈÎ áåçðàáîòíîãî],
 [Ðàáîòíèêè (îáðàçîâàíèå)].[Íàçâàíèå çàâåäåíèÿ]
FROM  [Ðàáîòíèêè (îáðàçîâàíèå)]
WHERE ((( [Ðàáîòíèêè (îáðàçîâàíèå)].[ÔÈÎ áåçðàáîòíîãî])
 IN (SELECT [ÔÈÎ áåçðàáîòíîãî] FROM  [Ðàáîòíèêè (îáðàçîâàíèå)] AS Tmp
 GROUP BY [ÔÈÎ áåçðàáîòíîãî]
 HAVING COUNT(*)>1 )));

http://www.sql.ru/forum/1254030/odnim-zaprosom-obedinit-dve-tablicy-i-nayti-povtornye-znacheniya-po-polu


 

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

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

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

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