东都太子(提问者) 回复 firegunzxselect * from uf_jqcjb --a
select * from docimagefile where imagefileid = 1298313 --b
select * from ImageFile where imagefileid = 1298313 --c
------------------分割线------------------------
SELECT tjr,gsmc,bmmc,tjrq,mdmc,jqxh,jqcmn,pzzp,kczt,jhsj,ssqy,xszt,jqcm,docid
FROM uf_jqcjb as a left join docimagefile as b left join ImageFile as c on a.pzzp=b.docid and c.imagefileid=b.imagefileid