I am trying to use the update statement below. I receive an error. I am sure it's syntax.
Here is the query as I originally run it:
FROM njobslstasks a INNER JOIN
lot_schedule_proposed_changes b ON a.PROGRESS_RECID_IDENT_ = b.progress_id
WHERE b.bldrcode = 'jima'
Here is how the management studio inside of the query window modifies it:
SET a.startdate = b.proposed_start_date, a.enddate = b.proposed_end_date
FROM rems.njobslstasks AS a INNER JOIN
rems.lot_Schedule_proposed_changes AS b ON a.PROGRESS_RECID_IDENT_ = b.progress_id CROSS JOIN
WHERE (b.bldrcode = 'jima')
I attached the error message as a screenshot