> 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)
> where ss.stu_index=345
> order by sc.pro_index

----- Original Message -----
From: "john_cantin" <kyukido@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, January 16, 2008 2:57 PM
Subject: [IBO] "rows ties" needs "order by"? newbee alert


> 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)
> where stu_index=345
> order by pro_index
>
> tia john cantin
>
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
> papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>