Re: BUG #4250: subquery in query

>>> "Wojciech Tylek" <wat@wat.net.pl> wrote:

> Why the query like:
>
> select * from b where a_id in (select a_id from a where b_id in
(10,20));
>
> does not return error?
> The table "a" does not have b_id!

This is a correlated subquery.  A previous list post on the topic:

http://archives.postgresql.org/pgsql-general/2007-06/msg01659.php

I hope this helps.

-Kevin