Hello, how can I CREATE VIEW containing subselect in query.
I have 2 tables
CREATE TABLE aaa (
id SERIAL,
name VARCHAR(20),
CONSTRAINT aaa_pk PRIMARY KEY (id)
) CREATE TABLE bbb (
id SERIAL,
fk_id INTEGER NOT NULL
counter INTEGER NOT NULL,
CONSTRAINT bbb_pk PRIMARY KEY (id),
CONSTRAINT aaa_fk FOREIGN KEY (fk_id)
REFERENCES aaa(id) ON DELETE CASCADE
)I would like to create follow view:
CREATE VIEW xyz AS
SELECT name, (SELECT SUM(counter) FROM bbb WHERE fk_id = aaa_temp.id)
FROM aaa AS aaa_temp
but the error has occured: "Syntax error or access violation;-5010 POS(68) Missing value specification."
When I try to run simple select, it works OK.
Can you help me how can I do this VIEW ?
Thanks, Julian _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
