Real simple and clear Join examples in mysql?

Question

MySQL

Join in mysql is very hard. Where to see real life examples, where you can simply and easily see how it works in practice?
Everything I find is dry and obscure

Answer 1

simple example
Table A
ID name
1 name1
2 name2
3 name 3
Table B
ID sername
1 fam1
3 fam3
4 fam4
Total join on ID B to A without any extra conditions will be
ID name ID sername
1 name1 1 fam1
2 name2 NULL NULL
3 name3 3 fam3
Or vice versa A to B
ID sername ID name
1 fam1 1 name1
3 fam3 3 name3
4 fam4 NULL NULL