in select

[Dmitry Lendel]

äÅÎØ ÄÏÂÒÙÊ.
åÓÔØ ÏÇÒÁÎÉÞÅÎÉÅ ÎÁ ËÏÌÉÞÅÓÔ×Ï ÚÁÐÉÓÅÊ, ËÏÔÏÒÙÊ ×ÏÚ×ÒÁÝÁÅÔ ÐÏÄÚÁÐÒÏÓ?
ðÒÉÍÅÒ
Select *
from Table1 A
where A.IDKey in (Select b.idkey from Table2 B)

-- 
Dmytro Lendel
www.bagel.com.ua