完全外部連接會取回左右兩張表的所有資料範例：輸出：Store_nameSalesTxn_DateRegion_NameStore_NameLos Angeles15001999-01-05WestLos AngelesSan Diego2501999-01-07WestSan DiegoLos Angeles3001999-01-08WestLos AngelesBoston7001999-01-08EastBostonnullnullnullEastNew York會將兩張表的資訊都依據on的欄位所串起來而在左表沒有相應欄位，故顯示nullANTI Outer join
%20join%EF%BC%9A%E5%AE%8C%E5%85%A8%E5%A4%96%E9%83%A8%E9%80%A3%E6%8E%A5/%E6%88%AA%E5%9C%96%202022-02-18%20%E4%B8%8B%E5%8D%883.54.51.png?t=0f64b7d6-b267-4108-8259-6197b1b3e56e)
