daily pastebin goal
55%
SHARE
TWEET

Untitled

a guest Jul 11th, 2018 48 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. A:
  2. ----
  3. ID |
  4. ----
  5.  
  6. B:
  7. --------
  8. config |  |
  9. --------
  10.    
  11. C:
  12. -------------------
  13. A.ID | B.config | Value
  14. -------------------
  15. 1 | paid | True
  16. 2 | paid | True
  17. 3 | paid | True
  18. 1 | dispatch | True
  19. 2 | dispatch | True
  20. 3 | dispatch | True
  21. 1 | delivered | True
  22. 2 | delivered | True
  23. 3 | delivered | True
  24.    
  25. INSERT INTO C (ID, config, Value)
  26. SELECT a.ID, b.config, 'True'
  27. FROM A a
  28. INNER JOIN B b
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top