Using Distinct

[FengShui1998]

Hello,

In Table A, I have a column called OwnerID that is unique. In Table B, I have multiple records of different OwnerIDs and purchases.

I'd like to list the distinct OwnerID from Table B and match them with Table A.

THanks ahead,

fengshui1998

 

[gmmastros]

I don't understand your question. Are you trying to find all OwnerId's that have at least one row in TableB?

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[markros]

Are you looking for this:

select OwnerID from TableA A where exists (select 1 from TableB B where B.OwnerID = A.OwnerId)

PluralSight Learning Library