那位神仙进来看看，这是啥东西？

[javason]

说能帮我说个大概的逻辑？讲个故事就行。我晕.......


这个东西大概是从几个oracle数据库里拿数据，然后在access里面生成个表，这段东东是从access里考出来的.... 多谢！！

SELECT "N_Assigned" AS REGION, GEPSREPUSER_GEPS_ORDER_HEADERS_DW.TITLE_XFER_POINT, "ORDER" AS ADV_REL, GEPSREPUSER_GEPS_ORDER_HEADERS_DW.SHIP_TO_CUST_NUM, GEPSREPUSER_GEPS_ORDER_HEADERS_DW.SHIP_TO_CUST_NAME, "Unknown" AS SITE_ALIAS, "Unknown" AS SITE_CPM, GEPSREPUSER_GEPS_ORDER_HEADERS_DW.TURBINE_NUM, GEPSREPUSER_GEPS_ORDER_LINES_DW.ORIG_SYS_ORDER_NUM, GEPSREPUSER_GEPS_ORDER_LINES_DW.ORDER_NUM, GEPSREPUSER_GEPS_ORDER_LINES_DW.LINE_NUM, GEPSREPUSER_GEPS_ORDER_LINES_DW.SHIPMENT_NUM, GEPSREPUSER_GEPS_ORDER_LINES_DW.QUANTITY, GEPSREPUSER_GEPS_ORDER_LINES_DW.STATUS, GEPSREPUSER_GEPS_ORDER_LINES_DW.GL_POSTED_DATE, GEPSREPUSER_GEPS_ORDER_LINES_DW.SHIP_DATE, GEPSREPUSER_GEPS_ORDER_LINES_DW.REQUEST_DATE, GEPSREPUSER_GEPS_ORDER_LINES_DW.PROMISE_DATE, GEPSREPUSER_GEPS_ORDER_LINES_DW.PART_NUM, GEPSREPUSER_GEPS_ORDER_LINES_DW.DESCRIPTION, GEPSREPUSER_GEPS_ORDER_LINES_DW.UNIT_SELLING_PRICE, GEPSREPUSER_GEPS_ORDER_LINES_DW.UNIT_LIST_PRICE, GEPSREPUSER_GEPS_ORDER_LINES_DW.LINE_TYPE, GEPSREPUSER_GEPS_ORDER_HEADERS_DW.CUST_PO_NUM, GEPSREPUSER_GEPS_ORDER_HEADERS_DW.SHIP_CUST_DUNS_NUM, GEPSREPUSER_GEPS_BILLING_LETTER_CALC_DW.PERCENT_TO_LIST, GEPSREPUSER_GEPS_ORDER_HEADERS_DW.SALES_CHANNEL, Null AS COLOR, Null AS QTR_YR, GEPSREPUSER_GEPS_ORDER_HEADERS_DW.SHIP_TO_SITE_ID, GEPSREPUSER_GEPS_ORDER_LINES_DW.LAST_UPDATE_DATE, GEPSREPUSER_GEPS_ORDER_LINES_DW.INVOICE_DATE, GEPSREPUSER_GEPS_ORDER_LINES_DW.SCHED_SHIP_DATE, GEPSREPUSER_GEPS_ORDER_LINES_DW.LINE_ID, GEPSREPUSER_GEPS_ORDER_LINES_DW.LINE_PRICE, CDbl(0) AS CURRENT_QTR_CLOSED, GEPSREPUSER_GEPS_ORDER_LINES_DW.BILLABLE_FLAG, GEPSREPUSER_GEPS_ORDER_LINES_DW.ENTER_DATE, GEPSREPUSER_GEPS_ORDER_HEADERS_DW.OA, GEPSREPUSER_GEPS_ORDER_HEADERS_DW.REQUEST_DATE AS HDR_RQST, GEPSREPUSER_GEPS_ORDER_HEADERS_DW.FRAME_TYPE, GEPSREPUSER_GEPS_ORDER_LINES_DW.ITEM_COST, GEPSREPUSER_GEPS_ORDER_LINES_DW.PLANNER_NAME, GEPSREPUSER_GEPS_ORDER_LINES_DW.PREPROC, GEPSREPUSER_GEPS_ORDER_LINES_DW.PROCESSING, GEPSREPUSER_GEPS_ORDER_LINES_DW.POSTPROC, GEPSREPUSER_GEPS_ORDER_LINES_DW.SHIP_METHOD, GEPSREPUSER_GEPS_ORDER_HEADERS_DW.PTS, GEPSREPUSER_GEPS_ORDER_LINES_DW.REASON_CODE, (0) AS PxQ, Null AS REQUEST_QTR, Null AS PROMISE_QTR, Null AS VENDOR, Null AS SUPPLY_IDENTIFIER, #1/1/1900# AS EST_SLS_DT INTO CS_ORDERS
FROM (GEPSREPUSER_GEPS_ORDER_LINES_DW INNER JOIN GEPSREPUSER_GEPS_ORDER_HEADERS_DW ON GEPSREPUSER_GEPS_ORDER_LINES_DW.ORDER_NUM = GEPSREPUSER_GEPS_ORDER_HEADERS_DW.ORDER_NUM) LEFT JOIN GEPSREPUSER_GEPS_BILLING_LETTER_CALC_DW ON GEPSREPUSER_GEPS_ORDER_LINES_DW.LINE_ID = GEPSREPUSER_GEPS_BILLING_LETTER_CALC_DW.LINE_ID
WHERE (((GEPSREPUSER_GEPS_ORDER_LINES_DW.STATUS)<>"CANCELLED") AND ((GEPSREPUSER_GEPS_ORDER_LINES_DW.LAST_UPDATE_DATE)>=#1/1/2005#) AND ((GEPSREPUSER_GEPS_ORDER_HEADERS_DW.MGMT_ENTITY) Like "Cont*")) OR (((GEPSREPUSER_GEPS_ORDER_LINES_DW.STATUS)<>"CANCELLED" And (GEPSREPUSER_GEPS_ORDER_LINES_DW.STATUS)<>"CLOSED" And (GEPSREPUSER_GEPS_ORDER_LINES_DW.STATUS)<>"FULFILLED") AND ((GEPSREPUSER_GEPS_ORDER_LINES_DW.LAST_UPDATE_DATE)<#1/1/2005#) AND ((GEPSREPUSER_GEPS_ORDER_HEADERS_DW.MGMT_ENTITY) Like "Cont*"));

[饮水需思源]

长度超长了吧

[笨笨兔兔兔兔兔]

这个不是sql语句么??

[zzzhang]

如果是这样就不难看出是什么东东了
SELECT "N_Assigned" AS REGION,
GEPSREPUSER_GEPS_ORDER_HEADERS_DW.TITLE_XFER_POINT,
"ORDER" AS ADV_REL,
.
.
.
FROM (GEPSREPUSER_GEPS_ORDER_LINES_DW
INNER JOIN GEPSREPUSER_GEPS_ORDER_HEADERS_DW
ON GEPSREPUSER_GEPS_ORDER_LINES_DW.ORDER_NUM =GEPSREPUSER_GEPS_ORDER_HEADERS_DW.ORDER_NUM)
LEFT JOIN
.
.
.
WHERE GEPSREPUSER_GEPS_ORDER_LINES_DW.STATUS<>"CANCELLED"
AND GEPSREPUSER_GEPS_ORDER_LINES_DW.LAST_UPDATE_DATE>=#1/1/2005#
AND
.
.
.

不过如上也太啰琐, 如数据表用别名写那就容易多了

[gmlwl]

同意楼上说法,

[雨中飞侠]

寒，怎么这么长！

[雨中飞侠]

寒，怎么这么长！