多个字段用in子查询应该怎么写？

[luxuinstan]

select * from a where ( (x,y) in (select (x,y) from b where z='010') )好象不行，应该怎么写？？？

[happyfish21cn]

select * from a where ( (x＋y) in (select (x＋y) from b where z='010') )

如果X,Y不算字符就加convert

[anddytang]

select * from a where x in (select x from b where z='010')
and y in (select y from b where z='010')

[yang771]

同意樓上的...頂..

[sqtwyj]

select * from a where exists(select x,y from b where a.x=b.x and a.y=b.y)