Union.

Question

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

Answer 1

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)

Answer 2

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,

Answer 3

ok. thanks for the help.