Tips on SQL Join
Inner join: Returns only the rows that have matching values in both tables. SELECT * FROM tableA INNER JOIN tableB ON tableA.id = tableB.id; TableA TableB 1 A 1 2 B 3 Result of INNER JOIN on id: id nameA nameB 1 A Alpha Outer Join: Returns rows that have matches + rows without matches,…
