SELECT ISNULL(T1.paytoname, T2.paytoname) paytoname,

ISNULL(T1.pname, T2.pname) pname,

ISNULL(contract1,'') contract1,

contract2,

ISNULL(Memcount1,0) Memcount1,

Memcount2,

Pcount,

ISNULL(Paid1,0) Paid1,

Paid2,

ISNULL(plans1,'') plans1,

plans2

FROM #table2 T2

LEFT JOIN #table1 T1 ON T2.paytoname = T1.paytoname