So IBConsole is creating inconsistent SQL. No surprise at all, since
even the InterBase BDP driver included with Delphi 2005 causes
"ambiguous field name" errors when used with FB :)

I sugest you to use IBExpert or any other tool that supports Firebird.

Carlos
http://www.warmboot.com.br
FireBase - http://www.FireBase.com.br


MS> Carlos H. Cantu wrote:

>> InterBase and Firebird 1.0 sometimes accepted "inconsistent selects"
>> without reporting error, and returning sometimes inconsistent data. FB
>> 1.5 check this and reports the error you are talking about. You need
>> to correct your select to be able to run it.
>>
>> Carlos
>> http://www.warmboot.com.br
>> FireBase - http://www.FireBase.com.br

MS> Hi Carlos,

MS> I'm not creating this select myself. I just double-clicked on the table
MS> name on IBConsole and I got this error. So should I drop IBConsole and
MS> use another administrarion tool?

MS> Marcelo