select * from a inner join b on a.id=b.id inner join c b.id=c.id
应该是可以的。这是我经常用的一个 select top 100 a.mrno,a.mrrev,a.part,c.description,c.specification,c.uom,a.totalqty,a.pono,a.poseq,a.reqdate,b.ordno,b.ordseq,b.part,d.description,b.qty from zz_ger_mrdetail a inner join zz_ger_mrhead b on a.mrno=b.mrno and a.mrrev=b.mrrev inner join inv10100 c on a.part=c.part inner join inv10100 d on b.part=d.part
inner join c b.id=c.id
select top 100 a.mrno,a.mrrev,a.part,c.description,c.specification,c.uom,a.totalqty,a.pono,a.poseq,a.reqdate,b.ordno,b.ordseq,b.part,d.description,b.qty from zz_ger_mrdetail a
inner join zz_ger_mrhead b
on a.mrno=b.mrno and a.mrrev=b.mrrev
inner join inv10100 c
on a.part=c.part
inner join inv10100 d
on b.part=d.part