34,588
社区成员
发帖
与我相关
我的任务
分享
select a.a,b.a,b.c,a.b from a left join b on a.a=b.a order by b.c
create table A (a varchar(10),b varchar(10))
insert into A values ('10','ww')
insert into A values ('20','aa')
create table B (a varchar(5),b varchar(10),c varchar(10))
insert into B values ('10','10','aa')
insert into B values ('10','20','bb')
insert into B values ('20','10','ss')
select a.a,b.a,a.b,b.c,a.b from a left join b on a.a=b.a
select * from a left join b on a.a=b.a
select * from a left join b where a.a=b.a