Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 2 of 2 total

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