Re: order of table joins or where clauses relevant? - olinux - com.mysql.lists.mysql

18 messages in com.mysql.lists.mysqlRe: order of table joins or where cla...

From	Sent On	Attachments
Adam Gerson	09 Jul 2003 06:46
nos...@unclassified.de	09 Jul 2003 07:41
Andy Eastham	09 Jul 2003 07:59
Adam Gerson	09 Jul 2003 08:08
Mike Hillyer	09 Jul 2003 08:18
Rudy Metzger	09 Jul 2003 08:19
Rudy Metzger	09 Jul 2003 08:33
Rudy Metzger	09 Jul 2003 08:47
nos...@unclassified.de	09 Jul 2003 09:17
olinux	09 Jul 2003 19:38
Krasimir_Slaveykov	09 Jul 2003 23:02
Heikki Tuuri	10 Jul 2003 02:17
Rudy Metzger	10 Jul 2003 03:01
vernon	10 Jul 2003 08:15
nos...@unclassified.de	10 Jul 2003 14:12
Rudy Metzger	11 Jul 2003 02:46
Adam Nelson	11 Jul 2003 08:18
Rudy Metzger	14 Jul 2003 01:42

Subject:	Re: order of table joins or where clauses relevant?
From:	olinux (ol...@yahoo.com)
Date:	07/09/2003 07:38:12 PM
List:	com.mysql.lists.mysql

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

--- nos...@unclassified.de 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...)