SELECT DISTINCT t.tradeSupportUserId, m.lastName + ', ' + m.firstName as fullName ,m.firstName, m.lastName, m.FSPro_UserID FROM tbl_TER_Territories t WITH (NOLOCK) INNER JOIN tbl_FSPro_Members m WITH (NOLOCK) ON t.tradeSupportUserID = m.FSPro_UserID WHERE t.ownerId = AND t.FSL_TableCode = AND COALESCE (t.tradeSupportUserId, 0) <> 0 UNION SELECT -1, '--Unassigned--', '', '', -1 ORDER BY lastName, firstName FOR json path, include_null_values