-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
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
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
>
