Select Distinct os_ticket.ticket_id As TicketNumber, os_user.name As Client, os_ticket.ip_address As IP, os_department.name As Departament, os_staff.username As Staff, os_ticket.source As Source, os_ticket.created As DataOn, os_ticket.duedate As DueDate, os_ticket.closed As ClosedDate, os_ticket.status_id As STATUS, os_help_topic.topic From os_ticket Join os_staff On os_staff.staff_id = os_ticket.staff_id Join os_department On os_ticket.dept_id = os_department.id Join os_user_email On os_ticket.user_id = os_user_email.user_id Join os_user On os_user_email.id = os_user.id Inner Join os_help_topic On os_ticket.topic_id = os_help_topic.topic_id + Inner Join os_thread_entry On os_ticket.ticket_id = os_thread_entry.object_id Would theoretically be correct then?