Details of different master records are equal - how to determine

Hi,

Suppose I've got the following tables:

Tables 1

DeptCombNo
(PK)

1
2

Table 2

DeptCombNo Deptcode
(FK)

1                       7NAH
1                       4ZIC
2                       3ZBE
3                       4ZIC
3                       7NAH

The field DeptCombNo of table 2 is foreign key to the primary key DeptCombNo of table 1, iow table 2 contains the details of table 1.

Now the question is: how do I set up a SQL-query that can tell me that details of DeptCombNo 1 and 3 are equal? I do not want to resort to PL-SQL or any other 3rd generation programming language.

I'm using Oracle 8.1.7.

Thanks in advance! Received on Sun Feb 13 2005 - 08:35:14 CST