select b.Station,c.Envent_desc,a.Pnum,d.Station,a.num,d.price as 目的价,b.price as 本站价,(d.price -b.price)*a.num as 应收票款 from
Test_Envent a
left join Test_Station b on a.Station=b.id
left join Test_Station d on a.AimStation=d.id
left join Test_EnventDesc c on a.Envent=c.Envent
create view vw_get
as
select 开始站名=(select stationDes from 站名表 where id=a.bstation),
人数=a.PNum,
目的站名=(select stationDes from 站名表 where id=a.EStation)
from 事件表 a
go