select distinct ownerid, fsl_tablecode
from tbl_prd_Products with (nolock)
where mfrId =
select shortdesc, ProdID, product
from tbl_PRD_Products with (nolock)
where ownerId =
and fsl_tablecode =
where OwnerID =
and FSL_TableCode =
and mfrId =
and crmactive = 'y'
and exists (select skuid
from tbl_prd_skus with (nolock)
where prodid = tbl_PRD_Products.prodid
and crmActive = 'Y'
and inactive = 0
)
order by shortdesc