Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Avoiding New Fields Causing Ambiguity Errors

Re: Avoiding New Fields Causing Ambiguity Errors

From: Bob Hairgrove <rhairgroveNoSpam_at_Pleasebigfoot.com>
Date: Tue, 07 May 2002 19:15:15 GMT
Message-ID: <3cd827a2.773452@news.ch.kpnqwest.net>


On 7 May 2002 11:35:49 -0700, topmind_at_technologist.com (Topmind) wrote:

>Title: Avoiding New Fields Causing Ambiguity Errors
>
>[SNIP]
>Is there any "best practices" standards that deal with this issue?

Yes ... always alias the table names in any query which involves more than two tables and include the alias in the SELECT list for each column (or else include the table name verbatim). Don't leave this to chance.

Bob Hairgrove
rhairgroveNoSpam_at_Pleasebigfoot.com Received on Tue May 07 2002 - 14:15:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US