[SQL] Subselect in join?

[Kenn Thompson]

Ok- Seems I've seen this somewhere, but can't seem to get it to work. Is my memory 
flawed, or is this just not an implemented feature?

SELECT * FROM (SELECT foo, bar FROM tfoobar)

In english- is it not possible to to a subselect in a FROM clause?

Kenn


____________________________________________
Kenn Thompson
Senior Web Architect
Adesta Communications
Work: 402.233.7595
Cell: 402.210.6326