Hi all,
it turns out that I'm trying to join a varchar(40) to an int(10). I didn't know MySQL allows this (and does it correctly, apparently through an intermediate table). Sorry to not have noticed earlier. Is there a way to get more strict behaviour, just to catch errors like this ? Thanks, Philip -- The mail transport agent is not liable for any coffee stains in this message ----------------------------------------------------------------------------- Philip Lijnzaad, [EMAIL PROTECTED] European Bioinformatics Institute,rm A2-08 +44 (0)1223 49 4639 Wellcome Trust Genome Campus, Hinxton +44 (0)1223 49 4468 (fax) Cambridgeshire CB10 1SD, GREAT BRITAIN --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php