| Subject | "rows ties" needs "order by"? newbee alert |
|---|---|
| Author | john_cantin |
| Post date | 2008-01-16T21:57:46Z |
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
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