高分SQL 连表查询提问（200分）

显示全部楼层 · 2008-12-9 22:11:12

Table T1
ID A B C
1000 Record a1 Record b1 Record c1
2000 Record a2 Record b2 Record c2
Table T2
T2_id ID D
1 1000 Record d1
2 2000 Record d2
3 1000 Record d3
Sample
Target:query just one result:ID, A, B, D (e.g. 1000, record a1, record b1, record d1)
Select T1.A, T1.B, T2.D
From T1 left join T2
On T1.ID=T2.ID
Where T1.C1 = record c1 /T2.D = record d1
上面两个表，T2中的ID是T1中ID是外键，
要查询一个记录，record a 1 , record b1, recordd1 ,record d3
完整的题看URL
http://hiphotos.baidu.com/mzcbjk/pic/item/87152b2dc66a7d29349bf7ce.jpg

千问 · 2008-12-9 22:11:12

没怎么看明白再写详细点吧declare @strvarchar(1000)declare @d varchar(20)declare @flag intdeclare @ID intset @str='('set @flag=0declare mycur cursor for select id,d from t2 where id=1000open mycurfetch next from mycur into @id,@dwhile @@fetch_status = 0 begin if @flag=0begin set @str=@str+@dend els...

千问 · 2008-12-9 22:11:12

T2中的ID是T1中ID的外键？能再清楚点吗？...

千问 · 2008-12-9 22:11:12

select a1,b1,d1,d3from t1,t2where t1ID=t2ID...