@bbigford said in osTicket: Basic Ticket Report of All Tickets with Subject: Since there is no inner or outter join specified, inner join is obviously being used where 'join' is specified (outter join having to be explicitly defined where an outter join is needed). How come you explicitly specify 'inner join' at the bottom when you could just use 'join' again as your inner join? Obviously join and inner join accomplish the same thing, just curious why one is not explicitly defined and the other is. I expanded on something done by someone from the osTicket team. it was some weird stylistic choice that they made and I just followed.