 <p>In that case you should be performing a <code>LEFT JOIN</code> instead like</p> <pre><code>SELECT SH1.[Sticker Price], SH1.[Credit Price], SH1.[Cash Price], SH1.[Credit Price], UG.Description as Value, CASE ROW_NUMBER() OVER(ORDER BY UG.Description) WHEN 1 THEN 1 ELSE 0 END as ISDEFAULT FROM [uStore].[dbo].[ACL_UserGroup] UG LEFT JOIN [uStore].[dbo].[ACL_UserGroupMembership] UGM ON UG.UserGroupId = UGM.UserGroupId LEFT JOIN [XMPDBHDS].[XMPieHDSSchema60].[Sheet1] SH1 ON CONVERT(nvarchar(100), SH1.[Centre Code]) = UG.Description WHERE UGM.UserId = 1012 AND SH1.[Credit Price] IS NOT NULL AND UGM.UserGroupId IS NOT NULL; </code></pre>