Reading your question a bit more. Do you actually want to customize your queries for specific collection-descriptors (which is what QueryCustomizer is for), or do you just want to perform complex queries?
If its the second option, complex queries are relatively straightforward once you get the hang of them. See the tutorials and query docs on the OJB site, and search the mailing list archives if you run into trouble. You don't want to use querycustomizer. Rob :) > -----Original Message----- > From: monish [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 27 January 2004 8:24 a.m. > To: [EMAIL PROTECTED] > Subject: complex joins > > > 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] > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
