Selecting details of Substitute Items from QuoteWerks database

The below T-SQL statement provides a template for selecting details of Substitute Items from the QuoteWerks SQL Server database. If you have any questions or if you’d like an equivalent for an Access backend, then please email development@hilltopsit.co.uk.

SELECT SH.SetName AS SubstituteSetName, SH.[Description] AS SubstituteSetDescription
    , SI.PartNumber AS SubstituteProductCode, PO.[Description] AS SubstituteProductDescription
FROM QuoteWerks.dbo.SubstitutionHeaders AS SH WITH (NOLOCK)
    INNER JOIN QuoteWerks.dbo.SubstitutionItems AS SI WITH (NOLOCK) ON (SH.ID = SI.SetID)
    INNER JOIN QuoteWerks.dbo.Products_QuoteWerks_Products AS PO WITH (NOLOCK) ON (SI.PartNumber = PO.ManufacturerPartNumber)