Hi. I have the need to pull a sample of 30 consumer accounts for every product code. The problem that I am running into is that there is a unique identifier, for every account, that gets eliminated when I run my select distinct to get the product codes. The tables are similar to this. Table1.UniqueID, Tabel1.ProductKey Table2.ProductKey, Table2.ProductCode Table2.UniqueID, Table3.AccountNumber If I run a select distinct on the first table to get the ProductKey (joined to Table2- to get the product code), I lose the UniqueID, which is the masked customer account unique ID. If I run a similar query on Table3, there is no way, that I know of, to guarantee that I will have all product codes represented. My end result should return something similar to this: Product1 Acct1 Product1 Acct2 Product1 Acct3 Product1 Acct4 etc... Product2 Acct1 Product2 Acct2 Product2 Acct3 Product2 Acct4 etc... I would greatly appreciate any advice on how to handle this.