Multiple tables

SELECT * FROM table1, table2 WHERE table1.colname = table2.colname; search data from two tables (not ideal way)
SELECT * FROM table1 INNER JOIN table2 ON table1.colname = table2.colname; search data joining two tables (inner is optional)
SELECT * FROM table1 a JOIN table2 b ON a.colname = b.colname; alias for he table names (keep sentence short)

INNER: shows only data present in both tables. Default mode
LEFT: shows all registries from the first table even in they don’t match any item from the second table
RIGHT: shows all registries from the second table even in they don’t match any item from the first table. Not supported on sqlite
OUTER: shows only data with no matches in the tables. Not supported on sqlite