I have two tables in the same db. Jobs and ImportedJobs. The ImportedJobs
contains jobs that will update multiple records and multiple fields in the
I can't seem to get this work with even updating one field - I need to
potential update all of the fields ...
Here's where I'm at ..
UPDATE Jobs SET company =
(Select company FROM ConvertedJobs
INNER JOIN Jobs ON Jobs.jobid = ConvertedJobs.jobid)
WHERE ConvertedJobs.Action ='Update';
Any help would be greatly appreciated !!
Happy Holidays ..