Can anyone help with this UPDATE statement please...?
SET JobShownInResults = JobShownInResults + 1
WHERE Jobs.JobID IN
[Query that returns list of IDs]
inner join Jobs
ON Jobs.JobId = Stats.ID
Can anyone help me?
No matter what I do with the join I get an 'incorrect syntax' error.