I have two tables,
Table 1 is Sales Summary Data
Table 2 is Contract pricing
Both have
Name
ItemNumber
ItemDescription
I Need to extract all the contract pricing from Table 2 and All Sales Data from Table 1 Based on a specific period (this would change based on the customer)
My Problem is that I end up losing any Contract pricing data where no sale has occurred I need all results from Contract pricing.
Where there is a sale that should be added where there is no sale just a 0 value and vice versa I require the items that had a sale but were not on the contract price list as well .
Thanks