I have a mapping table that I need to query to generate my report. The
table structure is as below:
Mapping table
m_id m_table m_dept org dept id table
1 1 1 1 2 1 2
1 1 1 1 2 2 3
1 1 1 1 3 1 1
Corresponding to tables 1, 2 and 3 I have tables t1, t2 and t3 with the
following structure
table t1
org dept id desc
1 1 1 table 1 dept 1
1 2 2 table 1 dept 2
Quering the mapping table:
Select * from Mapping where m_id = 1 and m_table=1 and m_dept = 1
returns 3 rows as above.
Now I need to write a query that would use the above query result and
display records from tables t1, t2 or t3 based on above mapping where
the org, dept and id is equal to that in mapping table.
e.g.
above query should return something like this:
org dept id desc
1 2 1 table 2 dept 2
1 2 2 table 3 dept 2
1 3 1 table 1 dept 3