I've two tables. Table one is named
RAW and table two is named
REPORT. Please see below screenshots. Both the tables are in Relationship with Column name
REQUESTID, however the only difference is -
RAW.REQUESTID and rest of the fields or
REPORT table are blank.
I'm looking for Query to fill data in
REPORT table but my conditions are
To INSERT Data in
REPORT.REQUESTID = RAW.REQUESTID AND RAW.LASTSTATUS= "NEW"
When above condition is true,
REPORT.NEW should have the value from
RAW.LASTUPDATEON. Result will look like below screenshot which I've manually filled.
Any help will be much appreciated.