Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...

alias specifies an alias for table-name. sql-expression is described in sql-expression. table-name can be one of the following: the name of a PROC SQL table. the name of a SAS data view. a ...