select sku.sku, sku.skudesc, sku.packsizedesc, sku.skuid, mfr.mfr_name, mfr.mfr_id
from tbl_prd_skus sku with (nolock)
inner join tblManufacturers mfr with (nolock)
on mfr.mfr_id = sku.mfrid
where sku.fsl_tablecode =
where sku.ownerid =
and sku.fsl_tablecode =
and sku.skuid in ()
order by sku.skudesc