Hi
I have below Data
select t0.docentry,t0.docnum, T0.PostDate,T0.Duedate, T0.itemcode ,T0.prodname,T1.ItemCode 'Component Item', T0.plannedqty as [Plan Qty], from owor T0 inner join wor1 T1 on T0.DocEntry = T1.DocEntry Id No Prod. Status Item Product Component Item issued 146 24400072 NULL FG10000081 Aspirin PM20000023 19.09 146 24400072 NULL FG10000081 Aspirin PM20000189 950 146 24400072 NULL FG10000081 Aspirin PM20000190 9501 146 24400072 NULL FG10000081 Aspirin PM20000191 950 146 24400072 NULL FG10000081 Aspirin PM20000192 14.661 146 24400072 NULL FG10000081 Aspirin PM20000193 190 146 24400072 NULL FG10000081 Aspirin PM30000038 8 146 24400072 NULL FG10000081 Aspirin SG10000044 5196 I want to display like it below Id No Prod. Status Item Product Component Item issued 146 24400072 NULL FG0000021 Aspirin P2000003 19.09 P2000019 950 P2000010 9501 P2000011 950 P2000012 14.661 P2000013 190 P3000008 8 S1000004 5196 16828.751
Thanks