• Dennis, to get the result set you need, you can do the following:

    select a.f1, b.f1, c.f1

    from t1 a

    full join t2 b on a.f1 = b.f1

    full join t3 c on c.f1 = ISNULL(b.f1, a.f1)

    John