Re: Difficult query (for me)

Stephane,

Sorry, further reading shows me that I'm dumb and you can already do this.

--------------------------
David Olbersen
iGuard Engineer
11415 West Bernardo Court
San Diego, CA 92127
1-858-676-2277 x2152


> -----Original Message-----
> From: David Olbersen
> Sent: Monday, April 07, 2003 9:32 AM
> To: pgsql-sql@postgresql.org
> Subject: RE: [SQL] Difficult query (for me)
>
>
> Stephane,
>
> SELECT
>   table1.recordname,
>   table1.value - table2.value
> FROM
>   table1,
>   table2
> WHERE
>   table1.recordname = table2.recordname
>
> Right?
>
> --------------------------
> David Olbersen
> iGuard Engineer
> 11415 West Bernardo Court
> San Diego, CA 92127
> 1-858-676-2277 x2152
>
>
> > -----Original Message-----
> > From: Stephane [mailto:sylfanie@club-internet.fr]
> > Sent: Friday, April 04, 2003 12:06 PM
> > To: pgsql-sql@postgresql.org
> > Subject: [SQL] Difficult query (for me)
> >
> >
> > Hello,
> >
> > Basicaly I have two tables like this:
> >
> > Table 1
> > RecordName Value
> > a          100
> > b          100
> > c          100
> > d          100
> > e          100
> > f          100
> >
> > Table 2
> > RecordName Value
> > a         25
> > b         50
> > c         75
> > g         150
> > h         150
> >
> > I would like a query that give me a result like this:
> > a         75 (100-25)
> > b         50 (100-50)
> > c         25
> > d         100
> > e         100
> > f         100
> > g         -150
> > h         -150
> >
> > It is table1-table2.
> > I could do it for records a,b,c but I do not how to have
> record which
> > are only in one of the two tables.
> > Thanks for your help.
> > Stephane.
> >
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> >
>