##What is an INNER JOIN?
Inner join returns records that match in both tables.
An inner join requires each row in the two joined tables to have matching rows
##What is an LEFT OUTER JOIN?
Left outer join has all tables in left table (say A). returns all the values from an inner join plus all values in the left table that do not match to the right table, including rows with empty values in the link column.
##What is an RIGHT OUTER JOIN?
A right outer join is just like left outer join reversed. Every row from the "right" table (say B) will appear in the joined table at least once. If no matching row from the "left" table (A) exists, NULL will appear in columns from A for those rows that have no match in B.
##Question - What does SERIAL do?
SERIAL is used for ids