>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/A >>Am I dreaming? Any ideas welcome.