create or replace view agent2customer as
select Agentid,min(resource_name) resource_name from agent a,
sim.res_customer b where a.assetid = b.resource_id group by a.agentid,b.resource_id order by resource_id
/
select Agentid,min(resource_name) resource_name from agent a,
sim.res_customer b where a.assetid = b.resource_id group by a.agentid,b.resource_id order by resource_id
/