yuvipoy (12/26/2012)

---

hi
i am having two tables one table is having header details and another is having data

Table_id Col_1 Col_2 Col_3 Col_4 Col_5 Col_6
1 Mytab_1_1 NULL Mytab_1_2 NULL Mytab_1_3 NULL


Ref_id Col_1 Col_2 Col_3 Col_4 Col_5 Col_6
1 1 NULL 2 NULL 3 NULL
1 9 NULL 8 NULL 4 NULL
1 4 NULL 5 NULL 6 NULL

i need to show to client as

There will be similarity between table1 and table2 which is NULL value.

Select Mytab_1_1,Mytab_1_2,Mytab_1_3 from table1 which will be header (i have ignored Null values)

Select *from table2 which is having data

my output will be something like

Mytab_1_1,Mytab_1_2,Mytab_1_3 ---header
1,2,3
9,8,4
4,5,6

Thanks

Select Col_1 As MyTab_1, Col_2 As MyTab_2, Col_3 As MyTab_3 From <TableName>