Trying to return empty rows even if data does not exsist in SQL
SELECT u.user_id, 
  column_name = COALESCE(MAX(change_date_time), '19000101')
  FROM dbo.users AS u
  LEFT OUTER JOIN dbo.audit_log_tx AS o
  ON u.user_id = o.user_id
  GROUP BY u.user_id;


Though I really don't like the use of token dates for missing data (especially 0).