I guess my question does not state what I am really trying to do which is better stated:

How can I list the unique ids that have a certain relationship count to other unique ids?

Hi, I am new here and was hoping to get an answer to a pretty simple question. I am using ORACLE 9i. Here is my question:

How can I list the rows that have a certain relationship count?

In my db I have a document table, an image table and an image_filing table. The image_filing table keeps track of the document to image relationships. It has a document_id column and an image_id column.

I want to list (in...