Hi,
I'm relatively new to OJB. Mapping simple queries was easy, however
when it comes to complex queries, its not very clear which straegy to use.
Can someone help out.
The query we trying to do is
SELECT D.col1
, D.col2
, D.col3
FROM $test.tableA A
, $test.tableB B
, $test.tableC C
, $test.tableD D
WHERE A.ITEM_STRUC_ID = '001'
AND A.LVL_RPT_CD = '60998030'
AND A.EFCT_DT <= CURRENT DATE
AND A.EXPR_DT > CURRENT DATE
AND B.ITEM_STRUC_ID = A.ITEM_STRUC_ID
AND B.ANC_LVL_ID = A.ITEM_LVL_ID
AND B.EFCT_DT <= CURRENT DATE
AND B.EXPR_DT > CURRENT DATE
AND B.VRTL_IND = 'R'
AND C.ITEM_STRUC_ID = B.ITEM_STRUC_ID
AND C.ITEM_LVL_ID = B.ITEM_LVL_ID
AND C.EFCT_DT <= CURRENT DATE
AND C.EXPR_DT > CURRENT DATE
AND D.KGF_STD_ITEM_CDE = C.KF_STD_ITEM_NBR
AND CURRENT TIMESTAMP BETWEEN D.EFFECTIVE_TMSTMP
AND D.END_EFFECT_TMSTMP
AND D.col3 IN ('A', 'D')
ORDER BY
thanks
Monish
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
