Hi, Salada, Duncan wrote: <cut> >select events_terms.* from events_terms left join events on >events_terms.events_ID=events.events_ID where isnull(events.events_ID); > >Can anyone tell me if that looks like it should have the desired effect? It >seems to, but I am going to eventually be using this to delete rows - not >find them - so I need to be sure. > >Thanks, >Duncan > select events_terms.* from events_terms left join events on events_terms.events_ID=events.events_ID where events.events_ID IS NULL;
ISNULL(<test>) is function equivalent to IF(<test> IS NULL, 'Some new value', <test>); Where <test> can be any valid expression -- Best regards -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Alexander Keremidarski <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria <___/ www.mysql.com M: +359 88 231668 --------------------------------------------------------------------- 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