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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
