Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT table1.col1, table2.col2 FROM table1, table2 WHERE table1.t_id = table2.t_id
- UNION
- SELECT table1.col1 FROM table1 WHERE table1.col4 = null
- SELECT table1.col1, table2.col2 FROM table1, table2 WHERE table1.t_id = table2.t_id
- UNION
- SELECT table1.col1, '' as col2 FROM table1 WHERE table1.col4 = null
- SELECT table1.col1, table2.col2 FROM table1, table2 WHERE table1.t_id = table2.t_id
- UNION
- SELECT table1.col1, 'whatever' FROM table1 WHERE table1.col4 is null
- SELECT table1.col1, table2.col2 FROM table1, table2 WHERE table1.t_id = table2.t_id
- UNION
- SELECT table1.col1, NULL AS col2 FROM table1 WHERE table1.col4 = null
- SELECT table1.col1, table2.col2
- FROM table1, table2 WHERE table1.t_id = table2.t_id
- UNION
- SELECT table1.col1, null
- FROM table1 WHERE table1.col4 = null
Add Comment
Please, Sign In to add comment