We are finally playing with data. To request data from a table or group of, we need to follow the following structure for the SELECT statement. Any changes in the syntax will break the statement and return an error.

	SELECT table1.field1,
		table1.field2...
		table2.field1,
		table2.field2...
	FROM table1
	INNER | (OUTER) LEFT | (OUTER) RIGHT table2
		ON table1.common_field1 = table2.common_field1...;

Download the class notes for day 2.

This entry is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International license.