SELECT DISTINCT ACL_ORDER TRA_CODE,
ACL_STORE TRA_TOCODE,
USR_DESC TRA_PERS,
to_char(ACC.ACC_DATE, 'yyyy-mm-dd') TRA_DATE,
COM.COM_DESC
FROM ACCEPTLINES ACL,
D7I_R5ORDERS ORD,
ACCEPT ACC,
D7I_R5COMPANIES COM,
D7I_R5USERS
WHERE TRA_DATE BETWEEN TO_DATE('2008-12-5', 'yyyy-mm-dd') AND
TO_DATE('2009-1-5', 'yyyy-mm-dd')
AND ACL.ACL_ORDER = ORD.ORD_CODE
AND ACL_ISPASS = 'N'
AND USR_CODE = ORD_BUYER
AND ACC.ACC_ORDER = ACL.ACL_ORDER
AND ORD.ORD_SUPPLIER = COM.COM_CODE
这条语句SELECT DISTINCT ACL_ORDER TRA_CODE,ACL_STORE TRA_TOCODE, USR_DESC TRA_PERS,这几句在这是什么意思?TRA_开头的是一个表的,ACL_开头的又是一个表的,USR_又是另外个表。
在这如果我要想加上时间查询的话,也就是 TRA_DATE BETWEEN TO_DATE('2008-12-5', 'yyyy-mm-dd') AND TO_DATE('2009-1-5', 'yyyy-mm-dd') AND....要加在哪呢?
ACL_STORE TRA_TOCODE,
USR_DESC TRA_PERS,
to_char(ACC.ACC_DATE, 'yyyy-mm-dd') TRA_DATE,
COM.COM_DESC
FROM ACCEPTLINES ACL,
D7I_R5ORDERS ORD,
ACCEPT ACC,
D7I_R5COMPANIES COM,
D7I_R5USERS
WHERE TRA_DATE BETWEEN TO_DATE('2008-12-5', 'yyyy-mm-dd') AND
TO_DATE('2009-1-5', 'yyyy-mm-dd')
AND ACL.ACL_ORDER = ORD.ORD_CODE
AND ACL_ISPASS = 'N'
AND USR_CODE = ORD_BUYER
AND ACC.ACC_ORDER = ACL.ACL_ORDER
AND ORD.ORD_SUPPLIER = COM.COM_CODE
这条语句SELECT DISTINCT ACL_ORDER TRA_CODE,ACL_STORE TRA_TOCODE, USR_DESC TRA_PERS,这几句在这是什么意思?TRA_开头的是一个表的,ACL_开头的又是一个表的,USR_又是另外个表。
在这如果我要想加上时间查询的话,也就是 TRA_DATE BETWEEN TO_DATE('2008-12-5', 'yyyy-mm-dd') AND TO_DATE('2009-1-5', 'yyyy-mm-dd') AND....要加在哪呢?
这句是很奇怪!不敢妄加断言,等高手!
表示查询ACL_ORDER TRA_CODE,ACL_STORE TRA_TOCODE, USR_DESC TRA_PERS,...这些字段组合后,都不重复的记录
应该是:
SELECT DISTINCT ACL_ORDER TRA_CODE,
ACL_STORE TRA_TOCODE,
USR_DESC TRA_PERS,
to_char(ACC.ACC_DATE, 'yyyy-mm-dd') TRA_DATE,
COM.COM_DESC,ACC.ACC_DATE
FROM ACCEPTLINES ACL,
D7I_R5ORDERS ORD,
ACCEPT ACC,
D7I_R5COMPANIES COM,
D7I_R5USERS
WHERE ACC.ACC_DATE BETWEEN TO_DATE('2008-03-5', 'yyyy-mm-dd') AND
TO_DATE('2009-11-5', 'yyyy-mm-dd')
and ACL.ACL_ORDER = ORD.ORD_CODE
AND ACL_ISPASS = 'N'
AND USR_CODE = ORD_BUYER
AND ACC.ACC_ORDER = ACL.ACL_ORDER
AND ORD.ORD_SUPPLIER = COM.COM_CODE
如:select name 姓名, sex 性别, age 年龄 from Person