Forum OpenACS Q&A: Response to Query problem after upgrade of PG and driver.

Posted by Don Baccus on
Oh, the reason your first example (sub-select) doesn't work is that it's not referring to the outer table.  It's a separate select on the table - the range variable (alias) refers to the first appearance of the table, only.

Does this make sense?