| can any one tell what is the order of execution of a query [message #230009] |
Tue, 10 April 2007 09:19  |
gvsunil1
Messages: 7
Registered: April 2007
Location: hyderabad
|
Junior Member |
|
|
can any one tell what is the order of execution of a query.
means how the records will fetch from the data base....tell me with some example...
thanks in advance
sunil.
SELECT DISTINCT CM.ID, CM.SHIPMENT_NO, CM.CORRECTION_ID, CM.ORG_APP_STATUS, CM.DEST_APP_STATUS,
CM.ORG_STATION, CM.DEST_STATION, CM.INVOICE_TYPE, CM.CORRECTION_TYPE,
CM.REASON_CODE, UM.USERID, CM.CRTD_TSTMP, MTRX.AMOUNT, MTRX.LEVEL_ID,
CM.FHL_FLAG, 'INR' CURRENCY_ID, ROLE.BUSINESS_UNIT_ID, TM.TERMINALID
FROM TERMINALMASTER TM, USERROLES ROLE, USERMASTER UM,
ROLE_APP_MAPPING MAP, CORRECTION_APPR_MATRIX MTRX, LV_CORR_MASTER CM
WHERE TM.ACCT_CONTROL_STATION = ROLE.BUSINESS_UNIT_ID
AND UM.ID = ROLE.USERMASTER_ID
AND ROLE.ROLEID = MAP.ROLE_ID
AND MAP.APPROVAL_ID = MTRX.ID
AND SUBSTR(MTRX.CORRECTION_TYPE_CODE, 2) = SUBSTR(CM.INVOICE_TYPE, 2)
AND ROLE.USERMASTER_ID = --4010
3783
AND CM.STATUS IN ('P', 'H')
AND UM.IS_ACTIVE = 'Y'
AND CM.DEST_APP_STATUS = 'P'
AND TM.OPER_ADMIN_FLAG = 'O'
AND CM.ORG_STATION = TM.TERMINALID
AND CM.CORRECTION_TYPE='F'
AND CM.ORG_APP_STATUS = 'P'
ORDER BY ID, AMOUNT;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
