I used a left outer join with a constraint on a joined row column value being null -- logically equivalent to a "not in" clause. Looks funny, but it works.
On Mar 11, 2012, at 10:52 PM, "Richard" <[email protected]<mailto:[email protected]>> wrote: 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
