At 08:57 AM 17/01/2008, you wrote:

>the following query (which has run under interbase 6.5) is giving me
>an error under firebird...
>
>select * from s_students ss
> left outer join s_contracts sc on
> (sc.stu_index=ss.stu_index and sc.contract_active='Y'
> left outer join d_programs d on
> (sc.program = d.program_code)

Following are not legal in Firebird:

> where stu_index=345
>order by pro_index

select
ss.*,
d.pro_index
from s_students ss
left outer join s_contracts sc on
(sc.stu_index=ss.stu_index and sc.contract_active='Y'
left outer join d_programs d on
(sc.program = d.program_code)
/* guessing location of WHERE and ORDER BY fields */
where ss.stu_index=345
order by d.pro_index

The Subject of this posting doesn't seem to relate to the content. ROWS TIES is idiosyncratic (non-standard) InterBase-specific syntax. Firebird introduces standard ROWS syntax in Firebird 2 as an alternative to SELECT FIRST n.- see the Fb 2 release notes for details.

Would you please separate IBO questions from Firebird/InterBase questions and post to the appropriate list[s]. - thanks.

Helen