Ensureing 1to1 relation with multiple Key Fields

Hi,

I have following problem:

I have two tables with about 10 million data sets each. Every Dataset is indentified by a unique (per table) combination of the datafields (lets call them c1, c2 and c3).

I need to find a SQL only Solution to filter out all all datasets that don't have a matching (same c1, c2 and c3) dataset in the other table.

Looking at the big amount of Datasets it must be done in a perfomant way.

Do you havb a tip how to try it?

Thanks
Simon
Frankfurt/Germany Received on Mon Feb 04 2002 - 11:26:05 CST