56,675
社区成员
发帖
与我相关
我的任务
分享
create table t1(id int primary key);
create table t2(id int primary key);
insert into t1 values(1),(2);
insert into t2 values(1),(3);
select * from t1
right join t2 on t1.id=t2.id;
select * from t2
left join t1 on t1.id=t2.id;