SELECT A.AMemo AS AMemmo, C.CInfo1 AS 'CInfo1', C.CInfo2 AS 'CInfo2',E.EName AS EName
FROM A inner join B on B.AID = A.AID
inner join C on ...
inner join D on ...
inner join E on ...
left join V on ((V.VNum = C.C1) OR (V.VNum = C.C2) OR (V.VNum = C.C3)) AND E.EID = V.EID---格式这样写
但是楼主原来的语句好像是少很多条件阿?
FROM A inner join B on B.AID = A.AID
inner join C on ...
inner join D on ...
inner join E on ...
left join V on ((V.VNum = C.C1) OR (V.VNum = C.C2) OR (V.VNum = C.C3)) AND E.EID = V.EID---格式这样写
但是楼主原来的语句好像是少很多条件阿?
------------------------------------
SELECT A.AMemo AS AMemmo, C.CInfo1 AS 'CInfo1', C.CInfo2 AS 'CInfo2',E.EName AS EName FROM A,B,C,D,E,V
WHERE B.AID = A.AID AND ((V.VNum = C.C1) OR (V.VNum = C.C2) OR (V.VNum = C.C3)) AND E.EID not in(select eid from V)
SELECT A.AMemo AS AMemmo, V.VInfo1 AS 'VInfo1', V.VInfo2 AS 'VInfo2',E.EName AS EName FROM A,B,C,D,E,V
WHERE D.DID = C.DID AND ((V.VNum = C.C1) OR (V.VNum = C.C2) OR (V.VNum = C.C3)) AND E.EID = V.EID
WHERE B.AID = A.AID AND
(V.VNum != C.C1) and (V.VNum != C.C2) and (V.VNum != C.C3)
AND E.EID = V.EID