I have 4 tables where the primary key is identical with the primary key of the other tables. Here's my strange result of two queries: select count(*) from tbl_a natural left join tbl_b natural left join tbl_c natural left join tbl_d where where tbl_c.field1=x and tbl_d.field2=y; Result: 7 matching rows select count(*) from tbl_a left join tbl_b using(ID) left join tbl_c using(ID) left join tbl_d using(ID) where where tbl_c.field1=x and tbl_d.field2=y; Result: 1016 matching rows Shouldn't be both queries match the same number of rows? (I'm using mysql 3.23.37 on a linux system) Thanks. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
