Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread select in select
Wed, Feb 19 2014 6:45 PMPermanent 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 AMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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
Image