Just answered a really simple question. Someone else answered:
SELECT j.job_id, j.name AS job_name, a.name AS advertiser_name, j.time_added, j.active, j.moderated
jobs j join advertisers a
WHERE a.advertiser_id = j.advertiser_id
There are two obvious problems that will prevent this approach from parsing: no FROM clause, and no ON clause after the JOIN.
Yet the answer has two upvotes. Am I missing something?