Testing if a record exists in another table [Resolved]

[olamm2k]

It works, but I'm not quite clear on the part between the 'LEFT JOIN' and 'ON' - the subquery followed by a table name. How does that work?