[SQL] Re: [GENERAL] Aggregates and joined tables...

2001-02-04 Thread Tom Lane
"omid omoomi" <[EMAIL PROTECTED]> writes: > The platform is PostgreSQL 6.5.2 on i386-unknown-freebsd3.2, compiled by gcc > 2.7.2.1 . > I want to write a query which looks like this : > select fa1 - sum(fc3) > from A,B,C > where fa1=fb1 and fb2=fc2 > group by fa1 ; > unfortunately I get this in r

[GENERAL] Aggregates and joined tables...

2001-02-04 Thread omid omoomi
Hi all, I have a problem using aggregate function SUM() ... The platform is PostgreSQL 6.5.2 on i386-unknown-freebsd3.2, compiled by gcc 2.7.2.1 . The story is that I need to join two tables with an aggregate function. Here is a sample model : Table A consist of ( fa1 , fa2 ) Table B consist of