getting reciprocal values from a table

[Taffy Smith]

Hi everyone,

Is there a way I can write an sql query to return reciprocal values from a single table?

for example, if I have the following rows:

  
c1  c2
-------
1   4
1   3
1   2
4   2
4   1

can I write a sql query that will return the first, and last row, since they have a reciprocal relationship? Or would I need to use a stored procedure with a cursor to loop through them all?

Thanks,
Taf

[Jeanne Boyarsky]

Taf,
How about doing a join (cartesian join that matches all of them) and see which come to the same value when diving a/b?