-

   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


: [1] []
 

:
: 

: ( )

:

  URL