Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 2 of 2 total |
Query and view (1.02 b1) |
Thu, Apr 5 2007 11:00 PM | Permanent Link |
"Ralf Bertoldi" | C/S remote with EDB Manager
- table1 9339 rows - table2 181 rows create a view 'myview': "SELECT * FROM table1 INNER JOIN table2..." - open the view (9339 rows browsing) - goto database/SQL - execute query: "SELECT * FROM myview" - resultset contains 12 records close all. - execute query: "SELECT * FROM myview" - resultset contains 9339 rows - goto view and open - 12 rows browsing If I create a view from just one table without joins everythings fine. ralf |
Fri, Apr 6 2007 4:08 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Ralf,
<< create a view 'myview': "SELECT * FROM table1 INNER JOIN table2..." - open the view (9339 rows browsing) - goto database/SQL - execute query: "SELECT * FROM myview" - resultset contains 12 records close all. - execute query: "SELECT * FROM myview" - resultset contains 9339 rows - goto view and open - 12 rows browsing If I create a view from just one table without joins everythings fine. >> Could you send me an example of what you're doing ? I tried the following here: CREATE VIEW "TestView" AS SELECT * FROM customer INNER JOIN orders ON orders.custno=customer.custno WHERE State='FL' And it shows 21 rows no matter how I access it - SELECT, open, etc. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |