Re: Issue With Subqueries

2011-11-09 Thread Mike Seda
:* Wednesday, November 09, 2011 7:19 AM *To:* Shawn Green (MySQL) *Cc:* Mike Seda; mysql@lists.mysql.com; Rong Chen *Subject:* Re: Issue With Subqueries Hi, mysql> select count(distinct field1) from db2.table1 where field1 not in (select field1

Issue With Subqueries

2011-11-08 Thread Mike Seda
All, Can anyone out there explain the result of the third statement provided below: mysql> select count(distinct field1) from db1.table1; ++ | count(distinct field1) | ++ | 1063 | ++ 1 row in set (0.01 sec