--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@...> wrote:

>
> At 04:45 AM 25/01/2012, IBO Support List wrote:
>
> Also, look at the SQL for your query. The statement you provided has not been valid in Firebird since v.1.0. At v.1.5 it would return warnings (which developers often ignore) and except only if there is an actual clash of column names; while, from v.2.0 onwards it will usually throw an exception, whether or not there is a name clash.
>
> SELECT ET_NAME, EQUIPMENT.*
> FROM EQUIPMENT
> LEFT JOIN EQUIP_TYPES ON ET_ID = E_TYPE
> ORDER BY LOWER(ET_NAME), LOWER(E_MAKE)
>

I am running this using Firebird 2.1 and I just tested this query and got no error, no warning, nothing to indicate that there is a problem.