'Anti join' diaporamas de présentation

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.

792 views • 9 slides