A single SELECT statement can now contain as many as eight different table references. Each usage of the same table name in a single statement counts as a separate table reference.
When using more than one table name in a SELECT statement, consider whether any column references in that statement clearly indicate to which table each column belongs. Where necessary, indicate which table each referenced column belongs to by specifying column names as follows: tablename.colname. A period must separate the table and column names.
|
Copyright © 2014 CA.
All rights reserved.
|
|