I need help to display multiple job numbers against a single release of a Sales Order using comma seperated values in a single row

Here is the Query From my BAQ:Pending_SO_Dashboard_Test.baq (41.6 KB)

Job%20against%20SO

Output of the Query is attached in an image and I need the highlighted Fields should be in a single line and a single column using comma seperated values.

select
[OrderHed].[OrderNum] as [OrderHed_OrderNum],
[OrderDtl].[OrderLine] as [OrderDtl_OrderLine],
[OrderRel].[OrderRelNum] as [OrderRel_OrderRelNum],
[JobProd].[JobNum] as [JobProd_JobNum],
[OrderHed].[OrderDate] as [OrderHed_OrderDate],
[OrderHed].[LegalNumber_c] as [OrderHed_LegalNumber_c],
[OrderHed].[PONum] as [OrderHed_PONum],
[OrderHed].[NeedByDate] as [OrderHed_NeedByDate],
[OrderHed].[ShipViaCode] as [OrderHed_ShipViaCode],
[OrderHed].[OrderComment] as [OrderHed_OrderComment],
[OrderHed].[ReadyToCalc] as [OrderHed_ReadyToCalc],
[OrderHed].[OrderHeld] as [OrderHed_OrderHeld],
[OrderHed].[ShipOrderComplete] as [OrderHed_ShipOrderComplete],
[OrderDtl].[PartNum] as [OrderDtl_PartNum],
[OrderDtl].[RevisionNum] as [OrderDtl_RevisionNum],
[OrderDtl].[SalesUM] as [OrderDtl_SalesUM],
[OrderDtl].[UnitPrice] as [OrderDtl_UnitPrice],
[OrderDtl].[OrderComment] as [OrderDtl_OrderComment],
[OrderRel].[Plant] as [OrderRel_Plant],
[OrderRel].[ReadyToFulfill] as [OrderRel_ReadyToFulfill],
[OrderRel].[Make] as [OrderRel_Make],
(isnull(OrderRel.SellingReqQty,0.000)) as [Calculated_SO_Release_Qty]
from Erp.OrderHed as OrderHed
inner join Erp.OrderDtl as OrderDtl on
OrderHed.Company = OrderDtl.Company
and OrderHed.OrderNum = OrderDtl.OrderNum
inner join Erp.OrderRel as OrderRel on
OrderDtl.Company = OrderRel.Company
and OrderDtl.OrderNum = OrderRel.OrderNum
and OrderDtl.OrderLine = OrderRel.OrderLine
left outer join Erp.JobProd as JobProd on
OrderRel.Company = JobProd.Company
and OrderRel.OrderNum = JobProd.OrderNum
and OrderRel.OrderLine = JobProd.OrderLine
and OrderRel.OrderRelNum = JobProd.OrderRelNum
order by OrderHed.OrderNum

1 Like

Thanks for the help.