Is it possible to use multiple UNION and UNION ALL in single structure from different tables? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

Is it possible to use multiple UNION and UNION ALL in single structure from different tables?

20th Mar 2016, 9:19 AM
Mayank Vaishnavi
Mayank Vaishnavi - avatar
2 Answers
+ 2
Yes.
28th Nov 2016, 10:09 AM
ViceKnightTA
ViceKnightTA - avatar
+ 1
Sure. You can have multiple tables and queries combined using the UNION statements, as long as the number of columns is the same across all tables.
26th May 2016, 12:53 PM
James Flanders