Hi Pooly!
>> mysql> SELECT criterio, idSite
>> -> FROM dominios_propios_completos
>> -> WHERE criterio NOT IN (
>> -> SELECT criterio_pub
>> -> FROM sites_criterios
>> -> );
>> Empty set (0.05 sec)
>
> Do you have NULL values in sites_criterios.criterio_pub ?
Yes Pooly, certainly it had. Thanks for your comment!! This was the
problem, again thank you very much.
I am now very ashamed as this is a newbie mistake. I was fooled because
I was pretty sure I had no NULL values, but you know... I'm not the only one
inserting values into the table. :-)
Cheers,
Jose Miguel.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
