Check out example codes for "only join in sql". It will help you in understanding the concepts better.

Code Example 1

They are functionally equivalent, but INNER JOIN can be 
a bit clearer to read, especially if the query has 
other join types (i.e. LEFT or RIGHT or CROSS) 
included in it.

Learn ReactJs, React Native from