Claims Table Mem_Num Clm_Id Clm_Amt 1 10 $50 2 20 $25 3 30 $15 Eligibility Table Mem_Num Pln_Id 1 AETNA 1 BCBS 2 CIGNA Results from Left Outer Join on Mem_Num Mem_Num Clm_Id Clm_Amt Pln_Id 1 10 $50 AETNA 1 10 $50 BCBS 2 20 $25 CIGNA 3 30 $15 N/A Required Results Mem_Num Clm_Id Clm_Amt Pln_Id 1 10 $50 AETNA 1 10 <B><I>$0</B></I> BCBS 2 20 $25 CIGNA 3 30 $15 N/AAm I dreaming? Any ideas welcome.