SELECT top 1 * FROM tbl_PRD_NutritionalClaims nc with (nolock) WHERE nc.OwnerID = AND nc.FSL_TableCode = select top 1 #_item# from tbl_PRD_NutritionalClaims with (nolock) where ownerid = and fsl_TableCode = and #_item# = '1' select * from qmd_getNutritionalClaims order by label