有这样的三个表
student
id name sex
1 a 1
2 b 0class
id class
1 1.3
3 2.2grade
id grade
1 99
3 79要求得到结果为
id name sex class grade
1 a 1 1.3 99SQL语句怎么写?谢谢!
student
id name sex
1 a 1
2 b 0class
id class
1 1.3
3 2.2grade
id grade
1 99
3 79要求得到结果为
id name sex class grade
1 a 1 1.3 99SQL语句怎么写?谢谢!
id name sex
1 a 1
2 b 0class
id class
1 1.3
3 2.2grade
id grade
1 99
3 79要求得到结果为
id name sex class grade
1 a 1 1.3 99
select a.id,a.name,a.sex,b.class,b.grade
from student as a
inner join class as b on a.id=b.id
inner join grade as c on a.id=c.id
insert into @t select 1,'a',1
union all select 2,'b',0declare @a table([id] int,class dec(10,1))
insert into @a select 1,1.3
union all select 3,2.2declare @b table([id] int,grade int)
insert into @b select 1,99
union all select 3,79select a.[id],a.[name],a.[sex],b.[class],c.[grade] from @t a,@a b,@b c where a.id=b.id and a.id=c.id
select s.id,s.name,s.sex,c.class,g.grade from student s,class c,grade g where s.id=c.id and c.id=g.id
insert into @t select 1,'a',1
union all select 2,'b',0declare @a table([id] int,class dec(10,1))
insert into @a select 1,1.3
union all select 3,2.2declare @b table([id] int,grade int)
insert into @b select 1,99
union all select 3,79select a.[id],a.[name],a.[sex],b.[class],c.[grade] from @t a,@a b,@b c where a.id=b.id and a.id=c.id and a.id=1
--加上id=1就可以了