Hi, Thank you for your help! I have gotten the answer from other site: SELECT IsNull(T1.AccountID, T2.AccountID) AS AccountID, ISNull(T1.Symbol, T2.Symbol) AS Symbol, T1.Fee, T1.Price, T2.Share, T2.Dollar FROM Table1 AS T1 FULL OUTER JOIN Table2 AS T2 ON T1.AccountID = T2.AccountID AND T1.Symbol = T2.Symbol ORDER BY AccountID, Symbol It's basically the same as the post from jose.