I have three tables (in XML) where I need to make a conditional join.
I now need to make a join to see what price the item had on 2016-03-01. something like
use PriceList.Price where max(ValidFrom) < SalesTable.Date
Is it possible to get help here?
The goal is to get the relevant sales price attached to each sales line.
it needs to be outer joins, not all sales lines has an matching Item and not all Items has pricelistIDs