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