五个表如下zm zone magent ma agent ac customerZM(ZID,MID) ZONE(ZID) MAGENT(MID) MA(MID,AGID) AGENT(AGID) AC(AGID,CID) CUSTOMER(CID)如何关联呀?
五个表如下zm zone magent ma agent ac customerZM(ZID,MID) ZONE(ZID) MAGENT(MID) MA(MID,AGID) AGENT(AGID) AC(AGID,CID) CUSTOMER(CID)如何关联呀?
ZM INNER JOIN ZONE ON ZM.ZID = ZONE.ZID
INNER JOIN MAGENT ON ZM.MID = MAGENT.MID
INNER JOIN MA ON ZM.MID = MA.MID
INNER JOIN AGENT ON AGENT.AGID = MA.AGID
INNER JOIN AC ON AGENT.AGID = AC.AGID
INNER JOIN CUSTOMER ON AC.CID = CUSTOMER.CID
from ZM A
inner join ZONE B on A.ZID=B.ZID
inner join MAGENT C on A.MID=C.MID
....