This join will be detected by the SQL Procedure and passed by the SAS/ACCESS engine directly to the DBMS server. The resulting rows will be passed back to the SAS System. proc sql; select tab1.deptno, ...

the name of a SAS data view. a query-expression ... The column names are prefixed with the table aliases so that the correct columns can be selected. proc sql; title 'Inner Join'; select * from ...