SELECT Product FROM tbl_PRD_Products with (nolock) WHERE ProdId = SELECT Sku FROM tbl_PRD_SKUs with (nolock) WHERE SkuId =