没有考虑转车的情况.....
没有做测试......select l.name
from line l, l_s ls_start, station s_start,
l_s ls_end,station s_end
where
ls_start.stationid=s_start.id
and ls_end.stationid=s_end.id
and s_start.name='武汉'
and s_end.name='广州'
and ls_start.lineid=ls_end.lineid
and ls_start.lineid=l.id
没有做测试......select l.name
from line l, l_s ls_start, station s_start,
l_s ls_end,station s_end
where
ls_start.stationid=s_start.id
and ls_end.stationid=s_end.id
and s_start.name='武汉'
and s_end.name='广州'
and ls_start.lineid=ls_end.lineid
and ls_start.lineid=l.id
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货