Respectful SQL Gurus,

I need to compare 2 different files which have same columns.
FILE 1 : policy, Amt1, Amt2, Amt3, Amt4, and Amt5... Amt16
FILE 2 : policy, Amt1, Amt2, Amt3, Amt4, and Amt5....Amt16

If any amount field in FILE 1 has ZERO, but has a value in the same amount field in FILE 2, then, I need to select that record.

It will be great, if i can show both values adjucent to each other.
Example : Policy#, 0.00/500.85

Any clue will be greatly appreciated. Oh, by the way, i use DB2. but, if you can give a hint in SQL SERVER, I can try change that in DB2.
Thank you so much
Raj

First, are you even talking about writing a query against tables? If you are then try looking at outer joins.
Dave