hi, how can I join two tables A and B so that the result is "In A but not in B"? let's take an example, say, the column to identify record is id. e.g. select A.* from A join B on (A.id = B.id) thanks. Richard
- how to join like a "In A but not in B" operat... Richard
- Re: how to join like a "In A but not in B&quo... Evan Pollan
- Re: how to join like a "In A but not in B&quo... sac . khurana
- Re:Re: how to join like a "In A but not i... Richard
- Re: Re: how to join like a "In A but ... Raghunath, Ranjith
- Re: Re: how to join like a "In A ... sac . khurana
- Re: how to join like a "In A but not in B&quo... sac . khurana