Re: using exists against entire column?
I would do this with a self-join:
SELECT ...
FROM mytable AS b
JOIN mytable AS d ON b.column_b = d.column_d
Anytime you need to compare values on one row to values on another row (or rows) in the same table, a self-join is probably the solution.
Regards,
Bill K.
Subject
Written By
Posted
December 07, 2006 12:59PM
Re: using exists against entire column?
December 07, 2006 01:53PM
December 07, 2006 02:06PM
December 07, 2006 11:01PM
December 09, 2006 04:09PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.