| SYNTAX HELP! [message #372155] |
Tue, 16 January 2001 16:11  |
elsie reed
Messages: 7
Registered: January 2001
|
Junior Member |
|
|
How can i change this Ms sql syntax to work in oracle pls help!
SELECT ACTIVITY_VALUE.ACTIVITY_VALUE_ID,
ARBOR_COMMON_DATA_LAYOUT.INVOICE_AMOUNT,
ARBOR_COMMON_DATA_LAYOUT.REPORTED_AMOUNT,
ARBOR_COMMON_DATA_LAYOUT.EXTERNAL_ID2,
ARBOR_COMMON_DATA_LAYOUT.TIE_CODE,
ARBOR_COMMON_DATA_LAYOUT.B_SERVICE_STATE,
ARBOR_COMMON_DATA_LAYOUT.B_SERVICE_GEOCODE,
ARBOR_COMMON_DATA_LAYOUT.UNITS,
ARBOR_COMMON_DATA_LAYOUT.PRODUCT_STOP,
ARBOR_COMMON_DATA_LAYOUT.DATE_RC_BEGIN,
ARBOR_COMMON_DATA_LAYOUT.BILL_PERIOD,
ARBOR_COMMON_DATA_LAYOUT.REV_RCV_COST_CENTER,
ARBOR_COMMON_DATA_LAYOUT.OWNING_COST_CTR,
ARBOR_COMMON_DATA_LAYOUT.HDR_JNL_END_DATE,
ARBOR_COMMON_DATA_LAYOUT.ARBOR_GL_ACCOUNT,
ACNA.ACNA_ID, ACTIVITY_TYPE.ACTIVITY_TYPE_ID,
ARREARS_BILLING_CODE.ARREARS_BILLING_CODE_ID,
BILL_DISTRIBUTION_CHANNEL.BILL_DISTRIBUTION_CHANNEL_ID,
BILLING_ELEMENT.BILLING_ELEMENT_ID,
CUSTOMER_ACCOUNT.CUSTOMER_ACCOUNT_ID,
FROM ARBOR_COMMON_DATA_LAYOUT INNER JOIN
ACTIVITY_VALUE ON
ARBOR_COMMON_DATA_LAYOUT.ID_VALUE = ACTIVITY_VALUE.ACTIVITY_VALUE_CODE
INNER JOIN
ACNA ON
ARBOR_COMMON_DATA_LAYOUT.REMARK = ACNA.ACNA_CODE
INNER JOIN
ACTIVITY_TYPE ON
ARBOR_COMMON_DATA_LAYOUT.ID_TYPE = ACTIVITY_TYPE.ACTIVITY_TYPE_ID
INNER JOIN
BILL_DISTRIBUTION_CHANNEL ON
ARBOR_COMMON_DATA_LAYOUT.DISTR_CHAN = BILL_DISTRIBUTION_CHANNEL.BILL_DISTRIBUTION_CHANNEL_DESC
INNER JOIN
BILLING_ELEMENT ON
ARBOR_COMMON_DATA_LAYOUT.ELEMENT_ID = BILLING_ELEMENT.BILLING_ELEMENT_CODE
INNER JOIN
CUSTOMER_ACCOUNT ON
ARBOR_COMMON_DATA_LAYOUT.EXTERNAL_ID = CUSTOMER_ACCOUNT.CUSTOMER_ACCOUNT_NUMBER
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
