Here is what my data looks like on the table I am querying
Table 1
ITEM SEQUENCE CODE
Item1 1 A
Item1 2 B
Item2 1 B
Item2 2 C
Item2 3 D
My current Query looks like
Select Distinct Table1.ITEM,
case when Table1.SEQUENCE = '1' Then Table2.DSC end As FirstDSC,
Case When Table1.SEQUENCE = '2' then Table2.DSC End As SecondDSC,
Case When Table1.SEQUENCE = '3' Then Table2.DSC End As ThirdDSC
From Table1
Join Table2 on Table2.Code = Table1.Code
Where Table1.Item In (Subquery here to find distinct values that Item can be)
It currently returns the data looking like
ITEM FIRSTDSC SECONDDSC THIRDDSC
Item1 DSC-A NULL NULL
Item1 NULL DSC-B NULL
I was wondering how to make the data return looking like
ITEM FIRSTDSC SECONDDSC THIRDDSC
Item1 DSC-A DSC-B NULL
Item2 DSC-B DSC-C DSC-D
Is there a good way to do this or am I going in the completely wrong direction with my query currently?
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire