Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT * FROM A
- LEFT JOIN B ON A.id = B.id
- WHERE A.name = 'text' OR B.other_name = 'text'
- SELECT * FROM A
- LEFT JOIN B ON A.id = B.id
- WHERE A.name = 'text'
- UNION
- SELECT * FROM A
- LEFT JOIN B ON A.id = B.id
- WHERE B.other_name = 'text'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement