Hi All

below are the table structures according to which I have to develop the desired output(given at the end)

tbl_docatr

docatr_id    doc_id     docatrtype_id   docatr_float    docatr_int  docatr_date     docatr_varchar  docatr_blob
    1       12            1              NULL            NULL        NULL            testing       [BLOB - NULL]
    2       12            2              NULL            NULL        NULL            Tesitng       [BLOB - NULL]

tbl_docatrtype

docatrtype_id   docatrtypegroup_id  docatrtypetype_id   docatrtype_name     
    1                      1                 4               Name    
    2                      1                 4             Company Name      

tbl_docatrtypetype

docatrtypetype_id   docatrtypetype_name
         1                Float
         2                Int
         3                Date
          4                String line

Above are three tables from which I have to display the desired output as

Name : testing     
Company Name : Tesitng     

such that at first step I have doc_id then I get docatrtype_id and then docatrtypetype_id acording to these values i have to fetch the result. Also the query must see the doactrtypetype_id from table tbl_docatrtypetype and fetch the result from tbl_docatr from respective column docatr_float, docatr_int, docatr_date, docatr_varchar, docatr_blob

Please help!!!