mysql: How to Join Several Tables

How to Join Several Tables

Very small and powerfull snippet

SELECT *
FROM
	tickets AS ti LEFT JOIN users AS u ON ti.user = u.id
	LEFT JOIN ticket_statuses AS ti_st ON ti.status = ti_st.id