Thanks for the reply. Here is the problem I have. I am doing a select * from a.table1, b.table2. When I am getting the field names I also need to know from which table is this column from. Some column names are identical. I hope I have explained my requirements. Thanks