create view 视图名
as
select a_id=a.id,a_name=a.name
,b_id=max(b.id),b_name=b.name --表2的id保留最大值
from 表1 a,表2 b
where a.name=b.name
group by a.id,a.name,b.name
create view 视图名
as
select a_id=a.id,a_name=a.name
,b_id=min(b.id),b_name=b.name --表2的id保留最小值
from 表1 a,表2 b
where a.name=b.name
group by a.id,a.name,b.name