Subject Re: [firebird-support] join and columns with the same name on diferent tables
Author Alexandre Benson Smith
At 21:29 06/04/2004 +0200, you wrote:


>I'm not sure, but I don't think the bug is in ISQL.
>
>If ISQL reports ambiguitythingy (or whatever you write it),
>it's most probably an SQL WARNING instead of an error.

ISQL reports it as a Warning.
SQL warning code = 204
-Ambiguous field name between table TABLE1 and table TABLE2
-NUMBER


and stops, don't return any row...

The others mentioned tools, don't show any message/warning/error and
returns wrong resultset.

>Or does ISQL have parsing etc build in?
>
>With regards,
>
>Martijn Tonies
>Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
>Server.
>Upscene Productions
>http://www.upscene.com
>

Thank you very much for your time...


Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br

----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.631 / Virus Database: 404 - Release Date: 17/03/2004


[Non-text portions of this message have been removed]