Union. | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

Union.

For Union, can i have my code as Select table1.column_name Union/Union all Select table2.column_name;

18th Jan 2019, 9:24 AM
Olujobi I. Ifeoluwa
Olujobi I. Ifeoluwa  - avatar
3 Answers
+ 3
It depends, union requires the number of selected columns and their types to be equal from both queries. Anyways, why not try to run it directly if you have a server to test with. P.S. Use relevant tags and be expressive on the title, at least include "sql", and not "Please answer" (not helping in deducting type and scope of topic)
18th Jan 2019, 10:30 AM
Ipang
+ 3
You're welcome : ) Please be advised with future posts, remember to use relevant tags, and descriptive title, it helps you gain more attention by having a clearly described question : ) Regards,
18th Jan 2019, 10:34 AM
Ipang
+ 1
ok. thanks for the help.
18th Jan 2019, 10:31 AM
Olujobi I. Ifeoluwa
Olujobi I. Ifeoluwa  - avatar