join on会查询出两张表中符合料件的内容
select * from ys_upload_file a join ys_notice b on a.notice_id = b.id where
b.id = '1'
左连接 会查询出左边表的字段
select * from ys_upload_file a left join ys_notice b on a.notice_id = b.id where
b.id = 'b612308e80714724822073e99197fbb6'
join on
最新推荐文章于 2024-06-25 20:58:19 发布