SQL JOINs
1. SELECT FROM TableA A INNER JOIN TableB B ON A.key=B.key2. SELECT FROM TableA A RIGHT JOIN TableB B ON A.key=B.key 3. SELECT FROM TableA A RIGHT JOIN TableB B
1. SELECT FROM TableA A INNER JOIN TableB B ON A.key=B.key2. SELECT FROM TableA A RIGHT JOIN TableB B ON A.key=B.key 3. SELECT FROM TableA A RIGHT JOIN TableB B