Re: Subquery and where clause ? - Mailing list pgsql-novice

Bo Lorentsen wrote:

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

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

/BL