Re: table joins or seperate begin-select clause

[Albert Howard <alhoward@concentric.net>]

BOB SHIFLETT wrote:
>
> Which is better for machine performance, to join several tables within a
> single begin-select clause or separate begin-select clauses?
>
> Thanx
>
> Bob

There is no easy answer to this. It depends on several factors.  If
there is a one-to-one correspondance between the tables, a join is
probably fine. If the tables are to be joined by non-key fields, a
single join is definitely the better choice.  And if an order by is
necessary by say, a title in the join, then of course the join is
needed.  In other situations, however, such as a join strictly by key
fields where there is no one-to-one correspondance, a sub-select might
work better.