SELECT
curr.Contract_Number AS [Contract_Number]
, 'AIU' AS [Vendor_Flag]
, sku1.SKU_Number AS [Current SKU_Number]
, sku2.SKU_Number AS [Correct SKU_Number]
, sku1.SKU_Description AS [Current SKU_Description]
, sku2.SKU_Description AS [Correct SKU_Description]
, sku1.Wholesale_Price AS [Current Contract_Wholesale]
, sku2.Wholesale_Price AS [Correct Contract_Wholesale]
FROM ((((
Current_Contracts curr)
INNER JOIN Correct_Contracts corr ON curr.Contract_Number = corr.Contract_Number)