如何将其转换为使用

如何将其转换为使用

如何将其转换为使用联接?

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

08-06 21:35