Mested select into the from of a a Select structure

From: Tourtounis Sotiris <tourtoun(at)csd(dot)uoc(dot)gr>
To: pgsql-general(at)postgresql(dot)org
Subject: Mested select into the from of a a Select structure
Date: 2002-11-09 16:49:04
Message-ID: Pine.GSO.4.44.0211091840340.24521-100000@syros.csd.uch.gr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Performing an SQL query of the below general form to a table T

Table T :

col1 | col2 | col3
------------------
text | text | text

and the query is ...

select *
from (select Y.col1 from ....) Z, T
where T.col2 = Z

I think this query should work - however it throws me an error to the
where clause, where it says that it doesn't find Z (ERROR: Attribute 'z'
not found) - can anyone notice any mistake or overlap that i have made - i
would really appreciate any kind of help or advice - thank you a priori
!!!

SWTHRHS TOYRTOYNHS
(tourtoun(at)csd(dot)uch(dot)gr)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jakub Ouhrabka 2002-11-09 16:59:41 Re: Mested select into the from of a a Select structure
Previous Message Richard Huxton 2002-11-09 16:34:16 Re: Win2K Questions