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