derived dipendent tables
------------------------
Key: CORE-3435
URL: http://tracker.firebirdsql.org/browse/CORE-3435
Project: Firebird Core
Issue Type: New Feature
Reporter: mauro russo
I would like to have the following SQL feature.
I would like to use a derived table, in a nested join, for which the definition
assume a eaning only according to the result of previous join.
For example :
select * from T1
join T2 on ....
join (select A.col1 from A where A.col2 = T2.colX order by A.col2 rows 1)
...
With such a select, I can "attach" to my query result a column [A.col1] to each
row according to the column values
of each row generated by the previous joins. Of course, in this case a new
derived table has to be computed
for each row generated by the previous joins, but this way to write seems to be
more easy and fast
respect using nested queries.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Xperia(TM) PLAY
It's a major breakthrough. An authentic gaming
smartphone on the nation's most reliable network.
And it wants your games.
http://p.sf.net/sfu/verizon-sfdev
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
