column types are the same so I don't know why this 'union all' is failing. Any ideas?
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
here is the error:
ERROR: syntax error at or near "UNION"
LINE 17: UNION ALL
^
********** Error **********
ERROR: syntax error at or near "UNION"
SQL state: 42601
Character: 278
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Here is the query:
with a as
(
select channel,node,accesses from storage where monthly = '11-06'
),
b as
(
select channel,node,accesses from storage where monthly = '11-07'
)
select
b.node
from a right join b on a.node=b.node
where a.accesses is null and b.channel = ('611 IVR')
order by node
UNION ALL
with a as
(
select channel,node,accesses from storage where monthly = '11-06'
),
b as
(
select channel,node,accesses from storage where monthly = '11-07'
)
select
b.node
from a right join b on a.node=b.node
where a.accesses is null and b.channel = 'olam'
order by node
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
here is the table structure:
-- Table: "storage"
-- DROP TABLE "storage";
CREATE TABLE "storage"
(
node character varying,
accesses double precision,
monthly character varying,
model character varying,
channel character varying,
qualified character varying,
bigintmark bigserial NOT NULL,
insertiondate timestamp with time zone NOT NULL DEFAULT now(),
CONSTRAINT aso PRIMARY KEY (bigintmark)
)
WITH (
OIDS=FALSE
);
ALTER TABLE "storage" OWNER TO postgres;