Hi Vijai, I have a question about your question: Will Assessments.ID be the same as Scores.subject_id and Subject.parent_subject_id?
They are different in your example (12 and 13), but I was wondering if that was a typo. Thanks, Ted On 08/02/06, VIJAISENTHIL, P. K. <[EMAIL PROTECTED]> wrote: > > Hi, > > I have a situation like, I need to pass a result (a String) of a query > to another SQL as parameter. > > E.g. like this. > > SELECT SCORING_LEVEL FROM ASSESSMENTS WHERE ID = 12; > > IF SCORING_LEVEL="THIS" > SELECT SUBJECT, MARK FROM SCORES WHERE SUBJECT_ID = 13; > ELSE > SELECT SUBJECT, MARK FROM SCORES WHERE PARENT_SUBJECT_ID = 13; > > Is it possible to configure or achieve this withthe XML file itslef > without coding it in JAVA? > > > Thanks and Regards > Vijai Senthil, P. K. >
