Watch, Follow, &
Connect with Us

Please visit our new home
community.embarcadero.com.

Public Report
Report From: InterBase/Server/Unsupported    [ Add a report in this area ]  
Report #:  9971   Status: Open
Please add support for table subqueries (derived tables)
Project:  InterBase Build #:  ?
Version:    7.1 Submitted By:   Kjell Rilbe
Report Type:  New Feature Request Date Reported:  12/21/2004 9:06:30 AM
Severity:    Commonly encountered problem Last Updated: 3/20/2012 2:24:39 AM
Platform:    All versions Internal Tracking #:   240497
Resolution: None (Resolution Comments) Resolved in Build: : None
Duplicate of:  None
Voting and Rating
Overall Rating: (5 Total Ratings)
4.40 out of 5
Total Votes: 31
Description
According to my SQL book, the SQL standard specifies that this construct should work:

select ...
from (
  select ...
  from ...
  where ...
) Subquery

But this doesn't work in IB. Please add support for this.
Steps to Reproduce:
None
Workarounds
None
Attachment
None
Comments

None

Server Response from: ETNACODE01