[snip "Chris"] The 'where' clause cuts that down to only matching records between the tables. Without the where, you'd end up with lots of rows but with the where it will be fine. [/snip]
Yes, it cuts it down to that number of records in the end, so the final result set will just be a few rows that match the 'WHERE'. But the internal process of MySQL do merge all tables and then chooses the records that matches the 'WHERE' clause. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]