I want to update a field in a table (Images) that contains a directory path to remove the first directory in that path. The problem is, I only want to update records that do not have a corresponding entry in another table (Products). I can't work out how to get the join to work. This is what I have, but it just errors:
left join Product on Product.frontcoverid = Images.id
Set Path = substring(Path, charindex('/',Path)+1, len(Path))
where Product.frontcoverid is null
I get : Incorrect syntax near the keyword 'left'.
... any ideas?