mysql - My sql select from multiple tables vs join -
how following compare join statement? select t1.name, t2.salary employee t1, info t2 t1.name = t2.name; would equivalent this? select t1.name, t2.salary employee t1, inner join info t2 on t1.name = t2.name; or more outer join? it without comma. select t1.name, t2.salary employee t1 inner join info t2 on t1.name = t2.name; to use inner join or left or right or ... results want get. related values or values exist in other table , on , here can learn joins. source