Home
Main website
Display Sidebar
Hide Ads
Recent Changes
View Source:
SubSelect
Edit
PageHistory
Diff
Info
LikePages
An [SQL] <tt>SELECT</tt> supplying a set for another <tt>SELECT</tt> to operate on in place of a table. <verbatim> select * from (select * from foo where bar) where baz select * from foo where baz in (select * from bar where quux) </verbatim> [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.
One page links to
SubSelect
:
PostgreSQL
