I can't complete the connection between the tables

mazheika

HELLO! Can someone please advise on how to now link to the purchase invoice? How to complete this chain?


SELECT *
FROM [Training$Sales Invoice Header$437] AS sih
LEFT JOIN [Training$Sales Invoice Line$437] AS sil ON sil.[Document No_] = sih.[No_]
JOIN [Training$Value Entry$437] AS ve ON ve.[Document No_] = sih.[No_] AND sil.[Line No_] = ve.[Document Line No_]
JOIN [dbo].[Training$Item Ledger Entry$437] AS ile ON ve.[Item Ledger Entry No_] = ile.[Entry No_]
WHERE ve.[Source Code] != 'INVTADJMT'
Categories: