Selecting details of Required Items from QuoteWerks database

The below T-SQL statement provides a template for selecting details of Required 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 RH.PartNumber AS PrimaryProductCode, PP.[Description] AS PrimaryProductDescription
    , RI.PartNumber AS RequiredProductCode, PO.[Description] AS RequiredProductDescription
FROM QuoteWerks.dbo.RequiredHeaders AS RH WITH (NOLOCK)
    INNER JOIN QuoteWerks.dbo.Products_QuoteWerks_Products AS PP WITH (NOLOCK) ON (RH.PartNumber = PP.ManufacturerPartNumber)
    INNER JOIN QuoteWerks.dbo.RequiredItems AS RI WITH (NOLOCK) ON (RH.ID = RI.SetID)
    INNER JOIN QuoteWerks.dbo.Products_QuoteWerks_Products AS PO WITH (NOLOCK) ON (RI.PartNumber = PO.ManufacturerPartNumber)