Annotated edit history of
SubSelect version 1, including all changes.
View license author blame.
Rev |
Author |
# |
Line |
1 |
AristotlePagaltzis |
1 |
An [SQL] <tt>SELECT</tt> supplying a set for another <tt>SELECT</tt> to operate on in place of a table. |
|
|
2 |
|
|
|
3 |
<verbatim> |
|
|
4 |
select * from (select * from foo where bar) where baz |
|
|
5 |
|
|
|
6 |
select * from foo where baz in (select * from bar where quux) |
|
|
7 |
</verbatim> |
|
|
8 |
|
|
|
9 |
[MySQL] lacked the functionality for years, until release 4.1. That truly sucked the smelly kumera. And now that it is finally implemented, it still has irritating limitations like prohibiting nested SubSelect~s. |