Advertisement
naimul64

WithdrawReportThanaDistrictUpdate

Jun 12th, 2017
423
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.35 KB | None | 0 0
  1. UPDATE
  2.     pesp_db_p23.stipend_withdraw_report swr
  3.     INNER JOIN pesp_db_p23_live.school sc
  4.       ON swr.school_code = sc.school_code
  5.     INNER JOIN pesp_db_p23_live.thana th ON sc.thana_id = th.id
  6.     INNER JOIN pesp_db_p23_live.district ds ON th.district_id = ds.id
  7.  
  8. SET swr.thana_name = th.name, swr.district_name = ds.name
  9. WHERE sc.thana_id <= 550
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement