sql - Difference between JOIN and INNER JOIN - Stack Overflow

What is the difference between Left, Right, Outer and Inner Joins? ... vs. SELECT * FROM table INNER JOIN otherTable ON table.ID = otherTable.FK. Is there any difference between the statements in performance or otherwise ? Does it differ .... Yes

stackoverflow.com