Guest User

Untitled

a guest
Dec 8th, 2016
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. SELECT start, from_number FROM mango
  2. UNION
  3. SELECT DateE, Message FROM email
  4.  
  5. SELECT
  6. start, from_number, DateE, Message
  7. FROM
  8. mango
  9. LEFT JOIN email ON mango.from_number != email.Message
  10.  
  11. select distinct x1,x2,x3
  12. from
  13. (
  14. SELECT start as x1 , from_number as x2, 1 as x3 FROM mango
  15. UNION
  16. SELECT DateE, Message, 2 FROM email
  17. ) as t
Add Comment
Please, Sign In to add comment