Re: SQL subquery to supply table name?

Scott Chapman wrote:
> I was lead to believe that Postgresql would handle this from reading the docs.
> This error message from psql made me think it would also:
>
> select txtcompanyname from (select table_quest from reviews where
> review_num=28) where review_num=28;
>
> ERROR: sub-SELECT in FROM must have an alias
> For example, FROM (SELECT ...) [AS] foo
>
> What is the "sub-SELECT in FROM" supposed to be used for if not this usage?
>

Read the error message again -- you just need an alias for the sub-select, e.g.:

select
t.table_quest
from
(select table_quest from reviews where review_num=28) AS t;
^^^^^
^^^^^

HTH,

Joe