Luc, You're the greatest! Now it works. Thank you. I am still puzzled,
though, as to the pervasive use of INTO - it works in other SQL
statements in my program - and inconsistent support by either Firebird
or the SQL standard. Is there a reference that compares Firebird
syntax to the current SQL standard?

Pete


--- In firebird-support@yahoogroups.com, Lucas Franzen <luc@r...> >

> Buit you misread it.
>
> INTO is not SQL it's PSQL and can't be used in standard selects.
> You can use it in Stored Procedures and triggers.
>
> Rewrite your statement to:
>
> SELECT min(id) from trays where tray_no = :aTray
>
> or
>
> SELECT min(id) AS ID from trays where tray_no = :aTray
>
>
> Luc.