mysql 中 join 和两表联合查询
mysql 中 left join, right join, (inner)join 和两表联合查询样例
样例表:customers, orders
运行结果:
left join:
select * from customers left join orders on customers.Id = orders.CustomerId;
right join:
select * from customers right join orders on customers.Id = orders.Cus
原创
2021-11-15 12:12:19 ·
808 阅读 ·
0 评论