Hello, > CREATE VIEW "test" > ( id, > nr ) > AS SELECT id, nr, anz FROM > (SELECT id AS id, nr AS nr, rownum AS anz FROM "M_RES"."TEST") > WHERE anz BETWEEN 5 AND 10 > > then come the error: > > Not yet implemented:SELECT IN FROM PART OF VIEW > > How can i solve best the problem? > Your statement seems unnecessary complicated. How about
CREATE VIEW TEST (id, nr) as SELECT id, nr FROM "M_RES".TEST WHERE rownum BETWEEN 5 AND 10 That should work. Peter Willadt _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
