Advertisement
Guest User

Untitled

a guest
Jul 23rd, 2019
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. SELECT IFNULL(customer_id,customer_id2), name, phone_num FROM(
  2. SELECT c.customer_id, name, p.customer_id AS customer_id2, phone_num
  3. FROM customers c
  4. LEFT JOIN phone_numbers p
  5. ON c.customer_id = p.customer_id
  6. UNION (
  7. SELECT *
  8. FROM customers c
  9. RIGHT JOIN phone_numbers p
  10. ON c.customer_id = p.customer_id)
  11. ) a
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement