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)
mysql> select count(distinct field1) from db2.table1;
+------------------------+
| count(distinct field1) |
+------------------------+
| 3516 |
+------------------------+
1 row in set (0.03 sec)
mysql> select count(distinct field1) from db2.table1 where field1 not in
(select field1 from db1.table1);
+------------------------+
| count(distinct field1) |
+------------------------+
| 0 |
+------------------------+
1 row in set (0.08 sec)
A colleague of mine is stating that the result should be much greater
than 0.
Please let me know what you think.
Thanks In Advance,
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org