"Raman Iyer [MS]" <ramaniy@online.microsoft.com> wrote in message
news:OQsZ$0WiFHA.3692@TK2MSFTNGP09.phx.gbl...
> [forwarding to a more appropriate newsgroup for this SQL question]
>
> --
> -Raman Iyer
> SQL Server Data Mining
>
>>> I'm trying to find orphaned records that resulted when a new table was
>>> created to normalize data but unnecessary records were added in the
>>> process.
>>> I have 2 related tables, let's call them tblA and tblB, that I need to
>>> compare.
>>> I need to first know where tblA.Name = tblB.Name then from that subset I
>>> need to know where tblA.ID(pk) does not match tblB.A_ID(fk).
>>> Sample Data:
>>> TblA.ID tblA.Name
>>> 1 ABC001
>>> 2 ABC321
>>> 3 ABC456
>>>
>>> TblB.ID tblB.Name tblB.A_ID
>>> 1 DEF901 4
>>> 2 ABC001 1
>>> 3 ABC456 2
>>>
>>> so my query would results would be:
>>> TblB.ID tblB.Name tblB.A_ID
>>> 2 ABC001 1
>>> 3 ABC456 3
>>>
>>> any help would be greatly appreciated, thanks.
>
>

"J" <J@discussions.microsoft.com> wrote in message
news:4C007F11-36AD-428B-B22B-6D2687BC1DBC@microsoft.com...
> Sorry my example should have looked like:
>
> Sample Data:
> TblA.ID tblA.Name
> 1 ABC001
> 2 ABC321
> 3 ABC456
>
> TblB.ID tblB.Name tblB.A_ID
> 1 DEF901 4
> 2 ABC001 1
> 3 ABC456 2
>
> so my query would results would be:
> TblB.ID tblB.Name tblB.A_ID
> 3 ABC456 2
>
>
> "J" wrote:
>
>> I'm trying to find orphaned records that resulted when a new table was
>> created to normalize data but unnecessary records were added in the
>> process.
>> I have 2 related tables, let's call them tblA and tblB, that I need to
>> compare.
>> I need to first know where tblA.Name = tblB.Name then from that subset I
>> need to know where tblA.ID(pk) does not match tblB.A_ID(fk).
>> Sample Data:
>> TblA.ID tblA.Name
>> 1 ABC001
>> 2 ABC321
>> 3 ABC456
>>
>> TblB.ID tblB.Name tblB.A_ID
>> 1 DEF901 4
>> 2 ABC001 1
>> 3 ABC456 2
>>
>> so my query would results would be:
>> TblB.ID tblB.Name tblB.A_ID
>> 2 ABC001 1
>> 3 ABC456 3
>>
>> any help would be greatly appreciated, thanks.

"J" wrote:

> I’m trying to find orphaned records that resulted when a new table was
> created to normalize data but unnecessary records were added in the process.
> I have 2 related tables, let's call them tblA and tblB, that I need to
> compare.
> I need to first know where tblA.Name = tblB.Name then from that subset I
> need to know where tblA.ID(pk) does not match tblB.A_ID(fk).
> Sample Data:
> TblA.ID tblA.Name
> 1 ABC001
> 2 ABC321
> 3 ABC456
>
> TblB.ID tblB.Name tblB.A_ID
> 1 DEF901 4
> 2 ABC001 1
> 3 ABC456 3
>
> so my query would results would be:
> TblB.ID tblB.Name tblB.A_ID
> 2 ABC001 1
> 3 ABC456 3
>