Select

SELECT col1, col2
FROM table1
WHERE col3 = "value";

Where

WHERE (col = 2 OR col1 = 2) AND (col3 = 4 OR col5 = 6);
-- do ands first so use ()

Sets

MAKE NOTES FROM HERE ZONED OUT!!!

INNER and OUTER JOINS

Note: used when looking at multiple tables

Note: Inner Join