1.2.5.4.Full join

• There is no direct statement or query for FULL join but we can achieve it by creating UNION on left and right join

• Full join displays all data from both tables corresponding to the columns and lists out the columns as mentioned on select.

• 將right join union/ union all left join的table

  • union all: 會保留重複的值

  • union: 不會保留重複的值