A
Al
the following is just a part of a sql for a union query:
***********************************
SELECT "a.4. Roofing - Membrane, Built-up, etc." AS Subsystem, "0_Backlog"
AS [Year], SumOfBacklog AS [Dollars]
FROM qrygraphForecastbySubsystem_1
Where Subsystem = "a.4. Roofing - Membrane, Built-up, etc."
Union All
SELECT "a.4. Roofing - Membrane, Built-up, etc." AS Subsystem, "2008" AS
[Year], SumOf2008 AS [Dollars]
FROM qrygraphForecastbySubsystem_1
Where Subsystem = "a.4. Roofing - Membrane, Built-up, etc."
Union All
SELECT "a.4. Roofing - Membrane, Built-up, etc." AS Subsystem, "2009" AS
[Year], SumOf2009 AS [Dollars]
FROM qrygraphForecastbySubsystem_1
Where Subsystem = "a.4. Roofing - Membrane, Built-up, etc."
Union All
SELECT "a.4. Roofing - Membrane, Built-up, etc." AS Subsystem, "2010" AS
[Year], SumOf2010 AS [Dollars]
FROM qrygraphForecastbySubsystem_1
Where Subsystem = "a.4. Roofing - Membrane, Built-up, etc."
***********************************************
When I exceeded 8 unions the query did not run, instead, I got an error
message saying that the query was too complex to run. I had to make 2
separate union queries that do not exceed 8 unions each. The total unions
that I needed was 13.
Does any one know what may be causing the problem. I have a feel that there
is no limitation on the number of unions that I could have in a union query.
it may by my sql.
thanks
Al
***********************************
SELECT "a.4. Roofing - Membrane, Built-up, etc." AS Subsystem, "0_Backlog"
AS [Year], SumOfBacklog AS [Dollars]
FROM qrygraphForecastbySubsystem_1
Where Subsystem = "a.4. Roofing - Membrane, Built-up, etc."
Union All
SELECT "a.4. Roofing - Membrane, Built-up, etc." AS Subsystem, "2008" AS
[Year], SumOf2008 AS [Dollars]
FROM qrygraphForecastbySubsystem_1
Where Subsystem = "a.4. Roofing - Membrane, Built-up, etc."
Union All
SELECT "a.4. Roofing - Membrane, Built-up, etc." AS Subsystem, "2009" AS
[Year], SumOf2009 AS [Dollars]
FROM qrygraphForecastbySubsystem_1
Where Subsystem = "a.4. Roofing - Membrane, Built-up, etc."
Union All
SELECT "a.4. Roofing - Membrane, Built-up, etc." AS Subsystem, "2010" AS
[Year], SumOf2010 AS [Dollars]
FROM qrygraphForecastbySubsystem_1
Where Subsystem = "a.4. Roofing - Membrane, Built-up, etc."
***********************************************
When I exceeded 8 unions the query did not run, instead, I got an error
message saying that the query was too complex to run. I had to make 2
separate union queries that do not exceed 8 unions each. The total unions
that I needed was 13.
Does any one know what may be causing the problem. I have a feel that there
is no limitation on the number of unions that I could have in a union query.
it may by my sql.
thanks
Al