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

Reply via email to