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:
e. Name e. Salary d. Name as emp_name, as salary, as dept name
Employee INNER JOIN
Department as e as d
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?