Îäíèì çàïðîñîì îáúåäèíèòü äâå òàáëèöû è íàéòè ïîâòîðíûå çíà÷åíèÿ ïî ïîëþ
|
|
Ïîíåäåëüíèê, 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
-
Çàïèñü ïîíðàâèëàñü
-
0
Ïðîöèòèðîâàëè
-
0
Ñîõðàíèëè
-