I want to join two tables into a view. Each table has a LONG column. When I SELECT from the view, the first LONG is blank. If I change one of the LONGs to a VARCHAR, it works fine. How can I get around this problem?
CREATE TABLE prima ( oid INTEGER, CONSTRAINT prima_pk PRIMARY KEY(oid), val long DEFAULT '') // CREATE TABLE sec1 ( oid INTEGER DEFAULT SERIAL, CONSTRAINT sec1_pk PRIMARY KEY(oid), CONSTRAINT sec1_fk FOREIGN KEY(oid) REFERENCES prima(oid) ON DELETE CASCADE, val long DEFAULT '') // CREATE VIEW V2 (OID, val, VAL1) AS SELECT P.OID, p.val, S1.VAL FROM PRIMA P, SEC1 S1 WHERE P.OID = S1.OID WITH CHECK OPTION // INSERT INTO v2 (oid, val, val1) VALUES (1, 'prima a', 'sec1 a') // INSERT INTO v2 (oid, val, val1) VALUES (2, 'prima b', 'sec1 b') // INSERT INTO v2 (oid, val, val1) VALUES (3, 'prima c', 'sec1 c') // select * from v2 Mike _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
