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
>
Yes...I'm aware of that and have tried also by maintaining extra table.
But how to to the following:
1. If insertion takes place, I want to return to the client the
values (with field names of course) which are inserted into the
tables. In each case table might be different.
2. If mo
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 20 June 2003 01:27, Anagha Joshi wrote:
> Yes...I'm aware of that and have tried also by maintaining extra table.
> But how to to the following:
> 1.If insertion takes place, I want to return to the client the
> values (with field names o
