Tutorial 26 – Union and Union All | PostgreSQL

In this video I explained Union and Union All operators.
UNION is used to combine the results of 2 or more SELECT statements. It removes any duplicate rows between the different SELECT statements. These select statements needs to have the same number of columns and similar data types for this join to be successful.
If you do not want to remove duplicates, then use UNION ALL operator.

Below is the link to the PostgreSQL Playlist
https://www.youtube.com/watch?v=oFaLUCWRnRE&list=PLACD_PaYcVF09khO58CISr08Uy6w3cAIF

Link to the INNER join video:
https://www.youtube.com/watch?v=t6aPwfAt1Ok

Link to the LEFT join video: https://www.youtube.com/watch?v=xJVT6SYfWTk&t=12s

Link to the RIGHT join video: https://www.youtube.com/watch?v=YiMD_IX-0gM

Link to the FULL OUTER join video: https://www.youtube.com/watch?v=HC-w_ZRkZL0&t=32s

Please don’t forget to LIKE, SHARE, COMMENT and SUBSCRIBE to our channel for more AWESOME videos.