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 --- [EMAIL PROTECTED] 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]