MySQL UNIONS are easy

[@BroCodez]

-- NO DUPLICATES
SELECT first_name, last_name FROM employees
UNION
SELECT first_name, last_name FROM customers;
-- DUPLICATES OK
SELECT first_name, last_name FROM employees
UNION ALL
SELECT first_name, last_name FROM customers;

[@markodarth]

I just wanted to say that sir are the greatest teacher about the matter you are teaching in the whole of internet. Thank you for doing what you are doing. Your videos have helped me a lot.

[@sargata3054]

Simple and easy to understand. Thanks!

[@sajadtorkamani9399]

Very good explanation - thanks :)

[@rajashekar4991]

Professional and clear explanation thank you

[@nicolewynne4781]

Please could you do PHP full course? Your videos are like an oasis in the desert for people like us who have financial struggles. Thanks a million BRO!!!

[@kristijanlazarev]

He already has one

[@sandrafitri4973]

Great tuorial

[@jabendi4573]

BRO, you DA best !

[@kristijanlazarev]

GODLIKEEE!!!

[@xKawaiNekox]

thank you, it is really helpful

[@Imariml]

Thank you, you really simplify it :)

[@gustavoaguilara.9873]

I love this video! ❤

[@Worldsbestdad505]

Sick video brah

[@kennymccormick9103]

Thank you very much!

[@theotisjames5873]

Which JOIN operater would work to combine no matter the column number?

[@suryateja6828]

can we create performed union as new table with a name?

[@whoissuhail]

same no. of columns having same datatype ?

[@IMHEMOX]

I needed this thanks bro🤍