On 02/03/2011, at 2:16 PM, Andy Colson wrote: > Its getting id1 from the parent table. (test2) You can use fields from the parent table in subselects. > > try this and it'll complain: > > select * from test2 where id1 in (select junk from test1) and charge=70; Oh! Of course! What a fool. Thanks =) --Royce -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
