finding values in TableA not in TableB

2002-05-02 Thread Salada, Duncan
I'm sure this question has been asked before, but I received an error while attempting to search the list archives - so I apologize for redunancy. I have two tables, events and events_terms, that have a common key, events_ID. Now I want to find the rows in events_terms that have an events_ID

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, Seoen

Re: finding values in TableA not in TableB

2002-05-02 Thread Alexander Keremidarski
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