Hi Tim,

This query works fine :-
------------------
select reportcat.name as category, report.id, report.name, report.options,
report.reporttype
from report
left join reportcat on (report.reportcat_id=reportcat.id)
order by reportcat.name, report.name
------------------

This one doesn't obey the ORDER BY clause :-
------------------
select reportcat.name as category, report.id, report.name, report.options,
report.reporttype
from report
left join reportcat on (report.reportcat_id=reportcat.id)
where report.options COLLATE UNI_CI like '%frmEditorPatient%'
order by reportcat.name, report.name
------------------

Here's the database you can test it with :-
http://files.pioneersoftware.co.uk/temp/SampleDB.7z

Hope this is an easy fix!

Has anyone else had this problem before or managed to reproduce it, or is it
just me?

Hedley,

<< This one doesn't obey the ORDER BY clause :- >>

Use the correlation name:

select reportcat.name as category, report.id, report.name, report.options,
report.reporttype
from report
left join reportcat on (report.reportcat_id=reportcat.id)
where report.options COLLATE UNI_CI like '%frmEditorPatient%'
order by category, report.name

I'll make sure that a fix is in 2.02 B9.

--
Tim Young
Elevate Software
www.elevatesoft.com