mysql - syntax of join in sql -

i want know syntax of joins in sql please regarding this

thanks

documentation

example query:

select u.id, m.phone_number user u join meta m on u.id=m.user_id; 

keep in mind join defaults inner join in mysql.

here's helpful visualisation of several types of joins, more examples.