select d.* from table1 d inner join (select * from (select a.idcard from table1 a inner join @idcardtable b on a.idcard=b.idcard and groupid=2) c) on c.idcard=d.idcard
select d.* from table1 d inner join (select a.idcard from table1 a inner join @idcardtable b on a.idcard=b.idcard and groupid=2) c on c.idcard=d.idcard
exec(' Select d.* from table1 d inner join (select * from (select a.idcard from table1 a inner join '+@idcardtable+' b on a.idcard=b.idcard and groupid=2) c) on c.idcard=d.idcard ')
select d.* from table1 d inner join ( select a.idcard from table1 a inner join @idcardtable b on a.idcard=b.idcard and groupid=2 ) c on c.idcard=d.idcard
(select * from (select a.idcard from table1 a
inner join '+@idcardtable+' b on a.idcard=b.idcard and groupid=2) c)
on c.idcard=d.idcard ')
(
select a.idcard from table1 a inner join @idcardtable b on a.idcard=b.idcard and groupid=2
) c
on c.idcard=d.idcard