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.

enter image description here

XPATH