CODEWITHSUNDEEP
mysql
Sharpeye500
Sharpeye500

Reputation: 9063

Writing a single query for mutliple queries with same where condition

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?

Upvotes: 0

Views: 57

Answers (1)

Alec
Alec

Reputation: 9078

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

Upvotes: 1

Related Questions