如何将其转换为使用联接?
SELECT j.job_id, j.name AS job_name, a.name AS advertiser_name, j.time_added, j.active, j.moderated
FROM jobs j, advertisers a
WHERE a.advertiser_id = j.advertiser_id
最佳答案
你可以用这样的连接来写:
SELECT *
FROM jobs j
JOIN advertisers a
ON a.advertiser_id = j.advertiser_id