SQL Syntax INNER JOIN
INNER JOIN Examples
SELECT Employee.Username
FROM Employee INNER JOIN Project
ON Employee.EmployeeID = Project.EmployeeID
WHERE Employee.City = 'Boston'
AND Project.ProjectName = 'Hardwork';
See also SQL syntax for:
MAXRIGHT JOINCreating an IndexViewing a TriggerVARP
