Page Comparison

SELECT
 CAST(p.objectPackageID AS VARCHAR) groupID,
 p.name title,
 p.notes scopeNote,
 (CASE WHEN u.MTB_ConstituentID = -1 THEN NULL ELSE u.MTB_ConstituentID END) owner
FROM
 ObjectPackages p
 LEFT OUTER JOIN Users u ON p.owner = u.loginUNIONlogin
UNION ALL
SELECT
  'bur' + CAST(o.objectID AS VARCHAR) groupID,
  'Burial lot ' + o.objectNumber title,
  null scopeNote,
  null owner
FROM
 Objects o
WHERE
   o.IsTemplate = 0 and o.IsVirtual=1 and o.DepartmentID = 34
 ;