How to make a subquery?

Question

MySQL

If we select only one field, and as a result of such a selection, IDs are formed, then we can do this:

SELECT `data`, `need`
FROM `tab2`
WHERE `id2` IN (SELECT `id1` FROM `tab1` WHERE...)

How to repeat the trick, provided that the inner query fetches more data:

SELECT `id1`, `data1`, `data2`
FROM `tab1` WHERE...

So in the selection, not only id1 but also data1, data2, is it possible to indicate inside IN that I am interested in id1 from the entire array?

Answer 1

SELECT `data`, `need`
FROM `tab2`
WHERE `id2` IN (SELECT id1 FROM  (SELECT `id1`,field1,field2  FROM `tab1` WHERE...) t)

but the meaning of this action eludes me completely ...