'Anti join' presentation slideshows

Nathalia Garay Gabriel Gonzalez Housing & Residential Life

203 views • 19 slides

INNER JOIN (EQUI-JOIN) Predicate

INNER JOIN (EQUI-JOIN) Predicate. source tables. SELECT * FROM employee, department WHERE employee.DepartmentID = department.DepartmentID. is equivalent to. SELECT * FROM employee INNER JOIN department ON employee.DepartmentID = department.DepartmentID.

795 views • 9 slides