nested AND loop Qery Question

  • Thread starter Thread starter aaaagc
  • Start date Start date
A

aaaagc

i have this table :
ID Course Detail1 Detail2 Detail3
St_1 Curse1 1 2 3
St_1 Curse2 1 2 3
St_1 Curse3 1 2 3
St_2 Curse1 1 2 3
St_2 Curse2 1 2 3
St_2 Curse3 1 2 3
St_3 Curse1 1 2 3
St_3 Curse2 1 2 3
St_3 Curse3 1 2 3

i need this report by using sql statment :

St_1 St_2 St_3
Curse1 Curse2 Curse3 Curse1 Curse2 Curse3 Curse1 Curse2
Curse3
1 1 1 1 1 1 1 1 1
2 2 2 2 2 2 2 2 2
3 3 3 3 3 3 3 3 3
 
They don't allow 2 columns in a crosstab query so you are going to have to
create 2 separate queries then join them together.
 
Back
Top