查询嵌套查询结果中的两个列

I'm writing a query like this:

我在写这样的查询:

select * from myTable where X in (select X from Y) and XX in (select X from Y)
se