Advertisement
naimul64

Untitled

Apr 18th, 2017
220
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.38 KB | None | 0 0
  1. UPDATE pesp_db_p23_live.duplicate_school dups
  2.         INNER JOIN
  3.     bugs.schoolRowCountReceiveddata_intermediate rdi ON dups.schoolCode1 = rdi.school_code
  4. SET
  5.     dups.R1 = rdi.RCount
  6. ;
  7.  
  8.  
  9. UPDATE pesp_db_p23_live.duplicate_school dups
  10.         INNER JOIN
  11.     bugs.schoolRowCountReceiveddata_intermediate rdi ON dups.schoolCode2 = rdi.school_code
  12. SET
  13.     dups.R2 = rdi.RCount
  14. ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement