Nick Upson wrote:

> I think I recall that the advice used to be that joins to stored procs
> should be the last joins done, is this still the case in 2.1

If stored procedure parameter is some column of some of the joined
tables, then yes. It's because data from table needs to be fetched to
supply the parameter to SP.

HTH

--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================