sql一个常用的两表关联查询的例子分享,涉及Left join、right join、Union、Order By、等SELECT 查询知识点
两张表A1、A2
要实现下面四种查询结果:
1.
2.
3.
4.
相对应代(自己写的代码经供参考):
1.
SELECT a1.id as id
, a1.name as A1
,a2.name as A2
FROM A1 a1 left join A2 a2 on a2.id=a1.id order by a1.id
2.
SELECT a2....
原创
2018-09-04 00:33:50 ·
6611 阅读 ·
0 评论