Mysq joins two table query, roughly divided into inner join, full join (outer join), right join, and left join....