Write SELECT statements to access data from more than one table using equijoins and nonequijoins
This SQL will create the Cartesian join between the two tables. If employees has N records and departments has M records we will have N * M records returned.
select * from employees, departments;
This query will return employees joined with there respective departments using an equijoin:
select * from employees, departments where employees.dept_id = departments.dept_id;
This query will return employees joined with the department they are not in using a nonequijoin:
select * from employees, departments where employees.dept_id <> departments.dept_id;
Join a table to itself by using a self-join
TODO
View data that generally does not meet a join condition by using outer joins
TODO
Generate a Cartesian product of all rows from two or more tables
TODO