extraction.

[SP_1]

Hi

I need help on extracting data from the following scenario.

There are 2 tables: TableA and TableB. The tables both have only 1 field in
each, called Alphabets.

TableA has 26 alphabets (A to Z) in the Alphabet field.

TableB has 5 alphabets (D to H) in the Alphabet field.

Is it possible to extract from TableA all those alphabets that are not
present in TableB ?? Can a query do this ? And how do I create that query
? In other words, the result of the extraction will be A to C and I to Z.

Thanks
Steve

 

[Allen Browne]

Use the unmatched query wizard (first dialog when you create a new query.)

 

[SP_1]

That was super.

Thanks so much
Steve

Use the unmatched query wizard (first dialog when you create a new query.)