Re: finding values in TableA not in TableB

2002-05-02 Thread Alexander Keremidarski
Hi, Salada, Duncan wrote: >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

Re: finding values in TableA not in TableB

2002-05-02 Thread Egor Egorov
Salada, Thursday, May 02, 2002, 4:45:01 PM, you wrote: Seoen> I'm sure this question has been asked before, but I received an error while Seoen> attempting to search the list archives - so I apologize for redunancy. Seoen> I have two tables, events and events_terms, that have a common key, Seo