Re: Details of different master records are equal - how to determine

"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message news:kIKdnRy9qq5k95LfRVn-vA_at_comcast.com...
>
> "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!
>>
>
>

have you tried the MINUS operator?

++ mcs Received on Sun Feb 13 2005 - 08:59:32 CST