Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 2 of 2 total |
Subselect in the FROM clause |
Fri, Feb 15 2008 9:11 AM | Permanent Link |
Bojan Sinkovic | Dear newsgoups readers,
I would like to include a subselect in my SQL statement in the FROM clause. How could I make something like SELECT iddata FROM (SELECT iddata FROM DATA) AS e work in ElevateDB? Bojan |
Fri, Feb 15 2008 4:21 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Bojan,
<< I would like to include a subselect in my SQL statement in the FROM clause. How could I make something like SELECT iddata FROM (SELECT iddata FROM DATA) AS e work in ElevateDB? >> Currently ElevateDB does not support derived tables, so you'll have to use a view for the inner sub-select instead. -- 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 |