Noah J SILVA wrote: > > Hi, > > I have three questions: > > The first concerns a query against two views bring down our > test database: > the query looks something like: > > create view view1 as > select a+b as no1, c as no2, d as no3 from table1 > > select * from view1, table2 where > view1.no1=table2.key > > Note how we want to match two fields concatenated from one > table against > one field from another table. Doing this directly didn't > seem to work, so > we came up with the idea to use a view. This seems to bring > down that > server instance! The full SQL is below. (I can supply the > complete table > definition if needed).
Mhm, I had to restart my database, too, when trying your select from two joinviews, will be fixed within the next versions. Thank you for reporting. So far no idea how to work around Elke SAP Labs Berlin > ... > > Thank you, > Noah Silva > IS&T - Programmer Analyst > (215) 419 - 7916 > > ----- Forwarded by Noah J SILVA/INT/CHEM/Corp on 05/29/2003 > 04:29 PM ----- > > > James ROBIE > 05/29/2003 04:26 PM > > > To: Noah J SILVA/INT/CHEM/[EMAIL PROTECTED] > cc: > Subject: SQL > > Here is the SQL for the views and the query. > > > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
