Writing a single query for mutliple queries with same where condition.

Question

select column1,column2,column3 from table1 where column5=0 and column6=0;

select column4 from table2 where column5=0 and column6=0;

These are two sql statements reading data from table1 & table2, is there a way instead of 2 single queries, can i write in a single query?

Thanks.

Answer 1

You could use UNION to combine the results:

SELECT
  column1,
  column2,
  column3,
  NULL AS column4
FROM table1
WHERE column5 = 0
  AND column6 = 0

UNION

SELECT
  NULL AS column1,
  NULL AS column2,
  NULL AS column3,
  column4
FROM table2
WHERE column5 = 0
  AND column6 = 0