Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: enterpulsejd
- Order by date
-
Subquery syntax
Thanks for the reply mirtheil. Those statement DO NOT in fact work, but we are on v8 so I assumed they would not. Do you know the proper syntax for a subquery in v8 PSQL? Or does v8 not support subqueries at all? What about temporary tables, like in SQL Server and Oracle. Are they possible...- enterpulsejd
- Post #4
- Forum: Pervasive: Pervasive.SQL
-
Subquery syntax
I'm trying to work out a simple subquery in Btrieve. I'm getting an error. This is just an example, I know I can do this query differently. I just need to know if there is a trick to subqueries in the FROM clause in Btrieve: select aropen.*, ca.Customer_Name from aropen, (select * from custadd)...- enterpulsejd
- Thread
- Replies: 4
- Forum: Pervasive: Pervasive.SQL
