>> Is it better to have one query or 3 or more SELECT?


> A JOINed query allows the optimiser to work out the best way to get
> all the information. It also saves on the connection, transmission and
> setup time overhead for each query.

And on the other hand, the join could cause some very large blob field
to be transmitted for each row, whereas 3 queries would do this only
once. So I guess the best answer is a bit situation-dependent.

Regards,
--
Willem Bogaerts

Application smith
Kratz B.V.
http://www.kratz.nl/