The diff is readability. I prefer the clarity of putting the condition under 'Join' and other cnditions under 'Where'.
The MySQL optimiser actually moves the Join to the Where clause, so there ought to be no performance diff between the two. PB ----- ----- Original Message ----- From: Anthony Ward To: [EMAIL PROTECTED] Sent: Thursday, June 05, 2003 1:53 PM Subject: Re: Join question Hi, what is the difference between your way and Mike Hillyer way?? (I can see the INNER join). But thanx to both of you. Anthony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
