gpt4 book ai didi

sql - 如何将其转换为使用 JOINS?

转载 作者:行者123 更新时间:2023-11-29 03:55:34 24 4
gpt4 key购买 nike

如何将其转换为使用 JOINS?

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

关于sql - 如何将其转换为使用 JOINS?,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/1899897/

24 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com