pass a result (a String) of a query to another SQL

[VIJAISENTHIL, P. K.]

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.