In table records as follows
Facid Q1 Q2 Q3 Batchid
1 2 3 4 B001
2 4 4 5 B001
1 5 1 2 B002
2 4 5 3 B002
1 4 1 2 B003
2 5 4 3 B003
Using above records i want output as follows using sql query
B001 B002 B003
Facid Q1 Q2 Q3 Q1 Q2 Q3 Q1 Q2 Q3
1 2 3 4 5 1 2 4 1 2
2 4 4 5 4 5 3 5 4 3
for getting a above output how can i write a sql query.
please help me.
Regards
Narasiman