Pre Learning Activities
A JOIN is a means for combining columns from one (self-join) or more tables by using values common to each. ANSI-standard
SQL specifies five types of JOIN: INNER, LEFT OUTER, RIGHT OUTER, FULL OUTER and CROSS. As a special case, a table (base table,
view, or joined table) can JOIN to itself in a self-Join.
A programmer declares a JOIN statement to identify rows for joining. If the evaluated predicate is true, the combined row is then produced
in the expected format, a row set or a temporary table.
Student required to take and understand the post-activity of the previous Chapter and complete the reading required prior the Main class activity. Read the following lecturer presentation notes before we start with the class session. You may also need to watch the video about data manipulation in MS. SQL Server