to all SQL experts...

I am stumped, although that's not really hard....

Here is my predicament:

I have a table that has 2 columns, column 1 repeats values and column 2 can have any value. Here's an example

col1        col2
1            15
1            35
1            46
1            72
2            10
2            35
2            46
2            11
2            19
2            22
3            15
3            35
3            46
3            72
4            11
4            25

Here's the dilemna...
I need a query that can find distinct col1 values that have matching col2 entries, along with the same number of entries. For example col1 value '1' has 4 entries with '15','35','46',and '72'. col1 value 2 has the entries 10,35,46,11,19 and 22. value 3 has 15,35,46, and 72. col1 values 1 and 3 have identical corresponding entries...the same values and the same number of entries. Can anyone help me out with this?? thanks, Chris. Received on Fri Aug 23 2002 - 21:02:17 CDT