"Shiva" <shiva087_at_hotmail.com> wrote in message
news:cunp6j$gqj$1_at_reader11.wxs.nl...
> 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:57:56 CST
