SQL relate 4 one to many tables
I have the below statement which is not giving me my desired output:
SELECT dbo.[Plan].Date, dbo.tbReceipt.ReceiptDate,
dbo.tbReceiptLine.ReceiptQty, dbo.Plan_Line.Pallets
FROM dbo.tbReceipt INNER JOIN
dbo.tbReceiptLine ON dbo.tbReceipt.PKId = dbo.tbReceiptLine.ReceiptId
INNER JOIN
dbo.[Plan] INNER JOIN
dbo.Plan_Line ON dbo.[Plan].PKId = dbo.Plan_Line.PlanId ON
dbo.tbReceipt.ReceiptDate = dbo.[Plan].Date
I must be relating these 2 sets of header/line tables incorrectly.
Anyone spot the error?
Thanks
No comments:
Post a Comment