SELECT id, data FROM
(
SELECT id, data FROM TestData
WHERE data % 2 <> 0
) as OddData
WHERE data IN
(
SELECT data AS number FROM TestData 
WHERE data % 3 = 0
)
{
{
OddData
TreData
