Hi,

I have this quite complicated SQL query that checks out ok in the report designer (when I click 'check sql' in the SQL editor), but when I close the window, I get this error:

"Error when building columns from the SQL select statement:
The column 'Quantity was specified multiple times for 'a'"

This is the SQL query:


SELECT
OD.OrderLineDescription,OD.Quantity, OD.SessionId,
OL.Quantity,
OSD.DeliveryNumber,
C.CustomerName
FROM dbo.OutgoingDetails OD
LEFT OUTER JOIN (
SELECT OutgoingDetailsId, SUM(Quantity) AS Quantity
FROM dbo.OutgoingLocation
GROUP BY OutgoingDetailsId
) AS OL on OD.Id = OL.OutgoingDetailsId
LEFT OUTER JOIN dbo.OutgoingSessionDelivery OSD on OD.SessionId = OSD.SessionId
LEFT OUTER JOIN dbo.Customer C on OSD.CustomerId = C.Id
WHERE OD.Quantity <> ISNULL(OL.Quantity, 0)

Can someone help me to modify it so I gets accepted?

Thanks,
Tom

Hi,

Thanks for your reply.
This is the query as it is accepted by sealreport:

SELECT
OD.OrderLineDescription,OD.Quantity, OD.SessionId,
Aantal_gepickt,
OSD.DeliveryNumber,
C.CustomerName
FROM dbo.OutgoingDetails OD
LEFT OUTER JOIN (
SELECT OutgoingDetailsId, SUM(Quantity) AS Aantal_gepickt --<--
FROM dbo.OutgoingLocation
GROUP BY OutgoingDetailsId
) AS OL on OD.Id = OL.OutgoingDetailsId
LEFT OUTER JOIN dbo.OutgoingSessionDelivery OSD on OD.SessionId = OSD.SessionId
LEFT OUTER JOIN dbo.Customer C on OSD.CustomerId = C.Id
WHERE OD.Quantity <> ISNULL(Aantal_gepickt, 0)