Ok, understood. One can access the columns of the main query from the subquery, therefore in my own query the column "id_compte" is found, therefore there is no error message.
Doesn't this count as a bug ? On Wed, Mar 16, 2005 at 02:24:48PM +0000, Richard Huxton wrote: > David Pradier wrote: > >Actually, the column "id_compte" is the primary key of the table "compte". > >The column "id_compte" doesn't exist in the table "operation". > > > >But i still don't understand why there is no error message, could you > >explain a little more ? > > I think it's intended for use in the WHERE clause: > SELECT a.* FROM a WHERE a1 IN (SELECT b3 FROM b WHERE b2=a2) > > -- > Richard Huxton > Archonet Ltd > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org -- [EMAIL PROTECTED] - tel: 01.46.47.21.33 - fax: 01.46.47.21.37 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
