my query gives multiple row per ticket. i want to list all custom values in one row. i want the val.value listed as columns against each ticket_id when i query my databaseSELECT ticket.ticket_id,ticket.`number`,ticket.dept_id,val.field_id,val.value,ticket.staff_id,ticket.team_id,user.name, email.EMAIL as email, dept.dept_name,status.state,status.name as status,ticket.source,ticket.isoverdue,ticket.isanswered,ticket.created FROM ost_TICKET ticket LEFT JOIN ost_ticket_status status ON status.id = ticket.status_id LEFT JOIN ost_user user ON user.id = ticket.user_id LEFT JOIN ost_email email ON user.id = email.email_id LEFT JOIN ost_department dept ON ticket.dept_id=dept.dept_id LEFT JOIN ost_form_entry entry ON ticket.ticket_id = entry.object_id LEFT JOIN ost_form_entry_values val ON entry.id = val.entry_id