表一: TableAAID Rid Lid
1 1 2
2 3 4
3 5 6
4 7 8
5 9 10表二: TableB
BID txt
1 a
2 b
3 b
4 e
5 f
7 g
8 h
9 j
10 k
其中,TableB是表的数据字典,TableA中的Rid和Lid均关联BID,现在查询TalbleA,要求将Rid,和Lid显示为对应的txt.
谢谢。
1 1 2
2 3 4
3 5 6
4 7 8
5 9 10表二: TableB
BID txt
1 a
2 b
3 b
4 e
5 f
7 g
8 h
9 j
10 k
其中,TableB是表的数据字典,TableA中的Rid和Lid均关联BID,现在查询TalbleA,要求将Rid,和Lid显示为对应的txt.
谢谢。
from tablea a left join tableb b on a.rid = b.bid
left join tableb c on a.lid = c.bid
set a.Rid=b.txt
from TableA a,TableB b
where aRid=b.BID
union
update a
set a.Lid=b.txt
from TableA a,TableB b
where aLid=b.BID
from TableA
left join TableB as tmp1 on TableA.Rid=tmp1.BID
left join TableB as tmp2 on TableA.Lid=tmp2.BID
selct a.AID,b.txt,c.txt
from TableA a,TableB b,TableB c
where a.Rid=b.txt and a.Lid=c.txt