> The reason this has me concerned is because I cannot seem to get

acceptable

> performance using LEFT JOIN with an order by clause instead of using join
> criteria in the WHERE clause.

If you want join criteria in the WHERE clause is all you have to do is put
it in the JoinLinks property and then IBO will put it in the WHERE clause
for you.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com