select shortdesc, ProdID, product
from tbl_PRD_Products with (nolock)
where ownerId =
and s.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