Re: order of table joins or where clauses relevant?

[olinux]

The order of the WHERE clause does make a difference.
The same is true of table joins. I don't think that
the order of tables in the FROM clause makes a
difference.

olinux


--- nospam@stripped wrote:
> As we're on this topic in another thread right now:
> 
> Say I have a SELECT query from more than one table
> and with some conditions, does it matter in what
> order I enter the tables in the FROM clause and in
> what order the WHERE conditions appear in my query?
> Or does it make any difference if I use WHERE or
> HAVING? (I see that MS Access likes those
> HAVINGs...)

__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com