Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 3 of 3 total |
select in select |
Wed, Feb 19 2014 6:45 PM | Permanent Link |
Ronald | Hi,
Is it possible to do s select in a select, in other words can I nest a select statement: select * from (select fieldname1,fieldname2 form table) Thanks, Greetings, Ronald |
Thu, Feb 20 2014 3:40 AM | Permanent Link |
Matthew Jones | To a small extent, yes. I was looking at this yesterday. Thing is, the inner select
must only return one field. See the WHERE clause section here: http://www.elevatesoft.com/manual?action=viewtopic&id=dbisam4&product=rsdelphi&versi on=XE&topic=SELECT_Statement /Matthew Jones/ |
Fri, Feb 28 2014 4:45 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Ronald,
<< Is it possible to do s select in a select, in other words can I nest a select statement: >> In ElevateDB, yes. In DBISAM, no. The embedded SQL SELECT in the FROM clause is called a "derived table". Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |