請教一下我要建一個視圖
字段有：
客戶代號,單號， 產品名稱,制令單號,預計完工,完成量,需領數量,已領數量,補料數量,補料單號,材料品號,品 名,規格C004,     C012,A034,A035, A001,     A010,   A017,B004,        B005,   E005,      E002,  E004,  E017,E018,
單位,制令單號,日期起，終      線別
E006,FTENO,FSELDATE,FENDDATE,G005
create view V_TE AS
select C004,C012.A034,A035,A001,A010,A017,T005,B004,B005,E005,E002,E004,E017,E018,E006,TENO,SELDATE,ENDDATE FROM
A LEFT JOIN B ON A.001=B.011 AND A.012=B.TA002
LEFT JOIN C ON B026=C.001 AND B027=C002
LEFT JOIN D ON A001=D001 AND A002-B002
LEFT JOIN E ON A001=E.TENO
(left(A002,8) BETWEEN CONVERT(CHAR(10),E.SELDATE,112) AND CONVERT(CHAR(10),E.ENDDATE,112))
 
把祂們關聯起來
急

[[it] 本帖最后由 jxyga111 于 2008-5-13 10:59 编辑 [/it]]