>Somehow they are not finding matches though (even though the two do match) because if I select the two matching fields in both tables, I see nulls in the 2nd table's fields in the result...
>
>
May be you do have NULLs in your second table.
Let's try INNER JOIN first then. See, if you get nulls.
If it's not broken, fix it until it is.
My Blog