select * from tbl_PRD_Products where ownerid = and fsl_TableCode = and product = 'ALL' order by mfrid, shortdesc update tbl_PRD_Products set product = where ownerid = and fsl_TableCode = and prodid =