Re: SQL subquery to supply table name?

Here's the details:
                                  Table "reviews"
             Column              |  Type   |               Modifiers
---------------------------------+---------+----------------------------------------
 review_num                      | integer | default
nextval('review_number'::text)
 table_quest                     | text    |

              Table "mpe_quest"
         Column         |  Type   | Modifiers
------------------------+---------+-----------
 review_num             | integer |
 txtcompanyname         | text    |

select foo.txtcompanyname from (select table_quest from reviews where
review_num=28) as foo where review_num=28;
It comes back and says No such attribute or function foo.txtcompanyname.

Scott

On Thursday 26 September 2002 04:04 pm, Scott Chapman wrote:
> I have a situation where a table contains table names.  I need to know if I
> can make a Postgresql query that will have a subquery which supplies the
> table name I want to deal with.  Can this be done?
>
> Something like this:
> select column from (select table_name from table2 where key=value) where
> key=value;
>
> Scott
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html