请大家看看这段sql代码错在哪里?
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
