posted 14 years ago
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:
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