Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE pesp_db_p23_live.duplicate_school dups
- INNER JOIN
- bugs.schoolRowCountReceiveddata_intermediate rdi ON dups.schoolCode1 = rdi.school_code
- SET
- dups.R1 = rdi.RCount
- ;
- UPDATE pesp_db_p23_live.duplicate_school dups
- INNER JOIN
- bugs.schoolRowCountReceiveddata_intermediate rdi ON dups.schoolCode2 = rdi.school_code
- SET
- dups.R2 = rdi.RCount
- ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement