sql+asp¶à±í²éѯÎÊÌ⣿£¿£¿

AÉÌÆ·±í
ma  spmc    ppbm   
 
B Æ·ÅƱí
ppbm  ppmc    jyb


CÏúÊÛ±í
xrq  ma  xsl  xje    ppbm  jyb

D½ø»õ±í
jrq  ma  jsl  jje    ppbm  jyb

EÆÚ³ö¿â´æ±í(ÿÔÂÒ»ÈյĿâ´æ£©
ma  qckc 

Òª°Ñ5¸ö±íµÄÐÅÏ¢¸ù¾ÝÈÕÆÚ(jrq ,xrq)Ìõ¼þÏÔʾÔÚÒ»¸ö±íÖÐ
ma  spmc  qckc  jsl  jje    xsl    xje    (qckc+jsl-xsl)  ppbm  ppmc


СµÜÔÚ´ËÏÈллÖîλÀ²£¡£¡£¡

---

±íB-(E,A)-(c,D)ÊÇÒ»¶Ô¶à¶Ô¶àµÄ¹Øϵ

---

ÒýÓÃ

select A.ma,A.spmc,E.qckc,jsl,xsl,xje,(qckc+jsl-xsl),ppbm,ppmc
from A inner join B on  A.ppbm = B.ppbm inner join C on A.ma = c.ma
inner join D on a.ma=d.ma inner join E on A.ma = e.ma
inner join E on A.ma = e.ma where Ìõ¼þ

Ìõ¼þÕâÑùд¿ÉÒÔÂð
"& eq("xtzl.ma", sp_m) & " and " &eq("xtzl.ppbm", pp_m) & " and " & eq("ppk.jyb", jyb_m) & " and " &dbfj & ".ma=xtzl.ma and "& dbfj &".ppbm=xtzl.ppbm and " & dbfj & ".jyb=ppk.jyb and " & dbfj & ".ppbm=ppk.ppbm and " & dbfx & ".ma=xtzl.ma and "&a