code_junkie

SQL - default columns

Nov 13th, 2011
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. SELECT table1.col1, table2.col2 FROM table1, table2 WHERE table1.t_id = table2.t_id
  2. UNION
  3. SELECT table1.col1 FROM table1 WHERE table1.col4 = null
  4.  
  5. SELECT table1.col1, table2.col2 FROM table1, table2 WHERE table1.t_id = table2.t_id
  6. UNION
  7. SELECT table1.col1, '' as col2 FROM table1 WHERE table1.col4 = null
  8.  
  9. SELECT table1.col1, table2.col2 FROM table1, table2 WHERE table1.t_id = table2.t_id
  10. UNION
  11. SELECT table1.col1, 'whatever' FROM table1 WHERE table1.col4 is null
  12.  
  13. SELECT table1.col1, table2.col2 FROM table1, table2 WHERE table1.t_id = table2.t_id
  14. UNION
  15. SELECT table1.col1, NULL AS col2 FROM table1 WHERE table1.col4 = null
  16.  
  17. SELECT table1.col1, table2.col2
  18. FROM table1, table2 WHERE table1.t_id = table2.t_id
  19. UNION
  20. SELECT table1.col1, null
  21. FROM table1 WHERE table1.col4 = null
Add Comment
Please, Sign In to add comment