|Subject||Re: LEFT JOIN AND ORDER BY|
> I guess you didn't test with fetching all records, because itshould have
> the same speed when fetching all records.Of course, I know about it. I use IBO and it fetches only those
records needed for display in the grid.
It seems, that the LEFT JOIN option is still the best approach
together with telling the users that they have to use search criteria.
Thanks Dimitry and Arno for your replies.