关于数据库关联查询问题

来源：百度知道 编辑：UC知道 时间：2024/07/08 01:20:42
现在有两个标表1“table1”表2“table2”
table1 table1
id name sex fid age class
1 yi nan 1 liu liu
2 er nan 2 qi qi
3 san nv
4 si nv
5 wu nv

我现在想表1和表2关联table.id=table.fid
查询出结果为如下的情况
id name sex fid age class
3 san nv null null null
4 si nv null null null
5 wu nv null null null
具体表如下,要用sql sever来写
table1
id name sex
1 yi nan
2 er nan
3 san nv
4 si nv
5 wu nv

table2
1 liu liu
2 qi qi

create table table1(id int ,name varchar(4),sex varchar(4))
insert into table1 values(1,'yi','nan')
insert into table1 values(2,'er','nan')
insert into table1 values(3,'san','nv')
insert into table1 values(4,'si','nv')
insert into table1 values(5,'wu','nv')

create table table2 (fid int ,age varchar(3),class varchar(3))
insert into table2 values(1,'liu','liu')
insert into table2 values(2,'qi','qi')

select * from table1 left outer join table2 on table1.id=table2.fid where table2.fid is null

drop table table1
drop table table2