Advertisement
Guest User

Untitled

a guest
Aug 29th, 2015
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.24 KB | None | 0 0
  1. SELECT * FROM A
  2. LEFT JOIN B ON A.id = B.id
  3. WHERE A.name = 'text' OR B.other_name = 'text'
  4.  
  5. SELECT * FROM A
  6. LEFT JOIN B ON A.id = B.id
  7. WHERE A.name = 'text'
  8.  
  9. UNION
  10.  
  11. SELECT * FROM A
  12. LEFT JOIN B ON A.id = B.id
  13. WHERE B.other_name = 'text'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement