Re: how to cache subtotals -- with subselect?

On Sun, Mar 02, 2003 at 11:17:45PM -0800, Stephan Szabo wrote:
> On Mon, 3 Mar 2003, Will Trillich wrote:
> > db=# update _person set
> > db-# been_client = (
> > db(# select count(*) from team t join involv_v v on (v.id=t.involv_v)
> > db(# where v.name='Client' and t.person=person.id
> > db(# );
> > NOTICE: Adding missing FROM-clause entry in subquery for table "person"
> > UPDATE 3
> >
> But the inner doesn't have a reference to _person, it has a reference to
> person, was it intentional to use different tables in those two places?

<blush>
um, no. sure wasn't.
</blush>

i'll go away now. (thanks for the eyeballs!)

--
There are 10 kinds of people:
ones that get binary, and ones that don't.

will(at)serensoft(dot)com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!

Looking for a firewall? Do you think smoothwall sucks? You're
probably right... Try the folks at http://clarkconnect.org/ !