Re: Getting one row for each subquery row...?

From: Együd Csaba <csegyud(at)freemail(dot)hu>
To: Tomasz Myrta <jasiek(at)klaster(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Getting one row for each subquery row...?
Date: 2003-06-20 07:02:58
Message-ID: 009201c336f9$fdb9ba70$230a0a0a@compaq
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Thank you Tomasz,
this last one seems to be good - with a little change.

select distinct t_stockchanges.productid, t_productgroups.name as pgroup
from t_stockchanges
join t_prod_in_pgr using (productid)
join t_productgroups on (t_productgroups.id=productgroupid);

Thank you again.
By,
-- Csaba

> Sorry, if you want all combination of grups and products, you need to
rewrite
> your query:
>
> select
> t_stockchanges.productid,
> t_productgroups.name as pgroup
> from
> t_stockchanges
> join t_prod_in using (productid)
> join t_productgroups on (id=productgroupid)
>
> or something like this.
>
> Tomasz
>

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com)
Version: 6.0.489 / Virus Database: 288 - Release Date: 2003. 06. 10.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Anagha Joshi 2003-06-20 08:27:04 Re: Latest transcation
Previous Message Tomasz Myrta 2003-06-20 06:11:58 Re: Getting one row for each subquery row...?