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
