Hi all. I've got a greenhorn question but I didn't find the right keywords to get Google to answer it for me.
Is it more efficient to put conditions in a JOIN instead of sticking them all at the end in the WHERE clause, or is that just a matter of preference? Putting conditions in the JOIN It seems, to me, to at least make the query easier to read. I was just curious if there were performance gains as well. Example: SELECT FROM table1 JOIN table2 ON this > that WHERE that = '5'; vs SELECT FROM table1 JOIN table2 WHERE this > that AND that = '5'; Thanks! G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
