Can someone please provide clarification on left joins and database views? I am not getting expected results. I want to get Incident where assignment group is sys id of helpdesk, and I want to join to sys_user a few times once for assigned to once for caller id etc, and I want ALL incidents from first one where helpdesk but i dont want to bring in all user tables. I have experience with SQL but its not behaving as id expect. Tried a few things and nothing works
