请问这样的sql语句怎么写啊？
表CivilProcess中字段：DocID,CaseId
表Cases中字段CaseId,CaseTypeId
表anbdmb中字段ID,name
如何用一条sql语句取出CivilProcess.DocID，anbdmb.name
条件是根据CivilProcess的CaseId到表Cases中找到CaseTypeId，然后根据CaseTypeId在表anbdmb中找到name.(其中CivilProcess.CaseId=Cases.CaseId、Cases.CaseTypeId=anbdmb.ID)
问题点数：40、回复次数：7Top
1 楼love007（风中的风）回复于 2004-12-02 15:52:39 得分 15
select a.DocID,b.name from CivilProcess a,Cases c,anbdmb b where a.CaseId=c.CaseId and c.CaseTypeId=b.IDTop
2 楼cbaryby（毛毛虫）回复于 2004-12-02 15:52:41 得分 5
select a.DocID,b.name from CivilProcess a
left join Cases c on a.CaseId=c.CaseId
left join anbdmb b on c.CaseTypeId=b.IDTop
3 楼lienzhu（李强）回复于 2004-12-02 15:53:47 得分 5
select CivilProcess.DocID,anbdmb.name from CivilProcess,Cases,anbdmb where CivilProcess.CaseId=Cases.CaseId and Cases.CaseTypeId=anbdmb.IDTop
4 楼a040liutao（冬之心）回复于 2004-12-02 15:56:20 得分 0
一条不行吧Top
5 楼fangq（jack）回复于 2004-12-02 15:59:27 得分 5
select a.DocID,b.name from CivilProcess a,Cases c,anbdmb b where a.CaseId=c.CaseId and c.CaseTypeId=b.ID
Top
6 楼znjgress（四空和尚）回复于 2004-12-02 16:01:56 得分 5
select a.DocID,b.name from CivilProcess a left join Cases c on a.CaseId=c.CaseId
left join anbdmb b on c.CaseTypeId=b.ID
Top
7 楼yayaleon801030（yayaleon）回复于 2004-12-02 16:04:47 得分 5
select CivilProcess.DocID, anbdmb.name
from CivilProcess inner join Cases on CivilProcess.CaseId=Cases.CaseId
inner join anbdmb on Cases.CaseTypeId=anbdmb.ID
-----------------------------------------------------
搞定接分Top
