I need to do something completely insane. I have 2 views that have the same number of columns (different column names though except the ID column) and they both happen to have
2 existing UNION queries. From my understanding UNION
and UNION ALL
only work when combining 2 SELECT
queries, here I'm trying to combine 4 of them! Aka the 2 views.
相关问题
- SQL join to get the cartesian product of 2 columns
- sql execution latency when assign to a variable
- Difference between Types.INTEGER and Types.NULL in
- php PDO::FETCH_ASSOC doesnt detect select after ba
- Bulk update SQL Server C#
"from my understanding UNION and UNION ALL only work when combining 2 SELECT Queries"
Ummmm...no. You can do something like the following:
etc, etc.