I have two tables. One is a subset of the other (call the subset table 2 and the larger table 2 is a subset of is table 1). I want to exclude from the larger table 1 the values in table 2.
Anyone have any idea how to do it. I figured a join would do it, but none that I have ever worked of will. I really want to do something like Select * when record not in table 2. But I don't know a filter that will do that either...
Anyone have any idea how to do it. I figured a join would do it, but none that I have ever worked of will. I really want to do something like Select * when record not in table 2. But I don't know a filter that will do that either...