select * from (select 1 as x, 0 as p) as a cross join (select 1 as y) as b inner join (select 1 as z, 0 as q) as c on a.x = c.z where a.p = c.q