thxuaimin

导航

 

access中的写法:

select * from

((spaceports as a left join flights  as b  on a.spaceport_id=b.departure_city) 

left join passengers as c  on b.flight_id = c.flight_id)

sqlserver中的写法:

select * from spaceports as a left join flights  as b 

on a.spaceport_id=b.departure_city 

left join passengers as c  on b.flight_id = c.flight_id

posted on 2013-08-26 16:57  thxuaimin  阅读(155)  评论(0编辑  收藏  举报