I am adding a new column called area_rep_id to the table ad_request. I have to update all the records with area_rep_no fronm blood_drives table where site_code from ad_request = site code from blood drives and similarly the drive date.
I have a query here.
set area_rep_id = (
from ad_request ar, blood_drives bd
where ar.drive_date = bd.drive_date
and ar.site_code = bd.site_code)
Is this correct?