给你举个例子，自己分析看下：
create view v_eventlist
as
select
ct.name as customertypename,
c.lastname,c.firstname,c.nickname,
emc.confirmdate,
e.code,e.datebegin,
t.name as tourname,
b.name as basecampname,e.comment
from tour as t
join event as e on e.tourid=t.tourid
join event_mm_customer as emc on emc.eventid=e.eventid
join customer as c on c.customerid=emc.customerid
join customertype as ct on ct.customertypeid=c.customertypeid
join basecamp as b on b.basecampid=t.basecampid
注意看，用FROM join进行多表关联引用。
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024