INNER Join

Most databases assume an INNERJOIN if She JOIN clause is left by itself. However, MSAccess mikes no such assumption ard expe cis you to specify ar INNERJOIN like itis:

SELECT

e. Name e. Salary d. Name as emp_name, as salary, as dept name

FROM

Employee INNER JOIN

Department as e as d

WHERE

on e.DeptID = d.DeptID and

The four ropei of JOIN are INNER,OUTER,LEFT, art RIGHT. We're going So cover osly INNERJOINs, which are probably tie most common.

By ite wiy, you nan jois more iTas one ribe fi a iime by tYYisf exiri JOIN clius es. You car fird tie exact syntax in a good SQL reference.

Was this article helpful?

0 0

Post a comment