I need HELP.

[maitrasuman]

I have the parent query with a column name 'RCPTMODE'. Based on the value derived from that I have to make child query from different tables with same data structures. How to do that ?

Example : if RCPTMODE value is "CASH" then I have to query from table A and if RCPTMODE value is "CHEQUE" then I have to query from table B.

 

[BJCooperIT]

              |------------------------|
              | SELECT RCPTMODE, ...   |
              | FROM PARENT_TABLE      |
              |------------------------|

|------------------------|  |--------------------------|
| SELECT ...             |  | SELECT ...               |
| FROM TABLEA            |  | FROM TABLEB              |
| WHERE :RCPTMODE='CASH' |  | WHERE :RCPTMODE='CHEQUE' |
|------------------------|  |--------------------------|

[sup]Beware of false knowledge; it is more dangerous than ignorance.[/sup][sup] ~George Bernard Shaw[/sup]
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
My website: Emu Products Plus