GuestRT

t966pk750

Jul 25th, 2018
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.30 KB | None | 0 0
  1. CREATE TABLE sandbox.yurbasov_t966pk750_secret
  2. AS
  3. WITH a AS
  4. (
  5. SELECT * FROM secret.regno s WHERE UPPER(regno) = 'Т966РК750'
  6. ), b AS
  7. (
  8.  SELECT * FROM a LEFT JOIN city_event_data.d_calc0a_regno_x_phoneno x ON x.carno = a.regno_hash
  9. ) SELECT * FROM b LEFT JOIN secret.phones s ON s.phone_hash = b.phoneno
Advertisement
Add Comment
Please, Sign In to add comment