Defining Complex Query ...

Hi All,

I have two tables.
First is CAT_TABLE_LIST ;
FIELD_NAME                   OPPOSITE_NAME    TBL_NAME
Height (mm)                            COL_1                 TBL_13
Cylinder volume (cm³)               COL_5                 TBL_13
Torgue (daN.m)                        COL_7                 TBL_13
Cylinder weight(kg)                   COL_13               TBL_13
Pump Type                              COL_9                 TBL_13
Fuel Consumption                    Col_22                 TBL_22
Color                                       Col_41                 TBL_09
--------------------------------------------------------------------
Second is TBL_13  (there are a few tables for each distict value for CAT_TABLE_LIST.TBL_NAME column );
STOCK_CODE              COL_1     COL_5    COL_7    COL_13      COL_9
FC-25                                12,5        5         15.000     45              DP 75
FT-45                                 27          9          40.000    35               DP 101
--------------------------------------------------------------------

the CAT_TABLE_LIST.TBL_NAME holds relevant table name and  CAT_TABLE_LIST.OPPOSITE_NAME holds columns names of  that relavant table.

The issue is, the columns of relevant tables dynamicly created. I mean if i insert new row to CAT_TABLE_LIST like that;

INSERT INTO CAT_TABLE_LIST ('Size(USA)','Col_77','TBL_13')
the new column will created for TBL_13 ;
ALTER TABLE TBL_13 ADD Col_77 VARCHAR(200)

And if i delete a row from CAT_TABLE_LIST, in the same transaction the
column will droped from relevant table, as follows
DELETE CAT_TABLE_LIST WHERE TBL_NAME ='TBL_13' AND OPPOSITE_NAME='Col_77'
go
ALTER TABLE TBL_13 DROP COLUMN Col_77
--------

Expected select query result is (for TBL_NAME = 'TBL_13' AND STOCK_CODE ='FC-25' ) .....

STOCK_CODE     OPPOSITE_NAME            FIELD_NAME                  VALUE
FC-25                        COL_1                     Height (mm)                     12,5
FC-25                        COL_5                     Cylinder volume (cm³)          5
FC-25                        COL_7                     Torgue (daN.m)                 15.000
FC-25                        COL_13                   Cylinder weight(kg)             45
FC-25                        COL_9                     Pump Type                        DP 75
------------------------------------------------------------------------------

How can i get this result ?

Thanks in advance...