Tom,

> In addition, you need to qualify every field in the statement of multi
> table selects.

This is only required where there are ambiguous references.

> Make sure the TABLE_NAME is included as part of the field.

It is not necessary to use the *Table Name*, but an *alias* as in:


FROM
MY_TABLE_1 T1
JOIN MY_TABLE_2 T2 ON T1.KEY_FIELD = T2.KEY_FIELD
WHERE


General Note: Using an alias is a good practice to use all the time.

>
> WHERE
> ZIP_CODE = '12345'
>
> may not use an index where
>
> WHERE
> ADDRESS.ZIP_CODE = '12345'

This is not necessary in the statement is not ambiguous.


Sean