Skip site navigation (1) Skip section navigation (2)

Re: Subquery and where clause ?

From: Bo Lorentsen <bl(at)netgroup(dot)dk>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Subquery and where clause ?
Date: 2001-08-22 12:34:58
Message-ID: (view raw or whole thread)
Lists: pgsql-novice
Bo Lorentsen wrote:

>     SELECT, A.count, B.count FROM C,
>         (SELECT COUNT( ) FROM A WHERE A.ref = AS A,
>         (SELECT COUNT( ) FROM B WHERE B.ref = AS B;

Arhh, the answer is simple, dont do this in the FROM clause ! :-)


In response to

pgsql-novice by date

Next:From: Bo LorentsenDate: 2001-08-22 13:02:45
Subject: Boolean SQL function ?
Previous:From: Bo LorentsenDate: 2001-08-22 12:18:53
Subject: Subquery and where clause ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group