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=listsearcharchive@lassosoft.com