> For the complete documentation index, see [llms.txt](https://jen-hsuan-hsieh.gitbook.io/database/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://jen-hsuan-hsieh.gitbook.io/database/chapter1/12mysql-for-beginners/125using-joins-to-combine-tables/1254full-join.md).

# 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: 會保留重複的值 ![](https://1088158622-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4M0G87SQJ28mvsXOhL%2F-M4M0IBPb1goOGpuG1BI%2F-M4M0QZ_Ldf6M6AUEySW%2F2018041431.jpg?generation=1586302933802477\&alt=media)
  * union: 不會保留重複的值 ![](https://1088158622-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4M0G87SQJ28mvsXOhL%2F-M4M0IBPb1goOGpuG1BI%2F-M4M0QZbgcwmDL5NHDwm%2F2018041432.jpg?generation=1586302933862771\&alt=media)