Re: Issue With Subqueries
:* 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
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