sorry if this is the wrong group...

so all i have to do is specify more clearly which table stu_index and
pro_index are in?


Helen Borrie wrote:

>
> 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
>
>