34,594
社区成员
发帖
与我相关
我的任务
分享
select *
from B
where id in(
select line_id
from station a
where station_name = '第二中学'
and exists(select * from station where line_id=a.line_id and station_name = '商城')
)
select a.line_id
from a,b
where a.line_id = b.line_id and station_name in ('第二中学','商城')
select *
from station a
where station_name = '第二中学'
and exists(select * from station where line_id=a.line_id and station_name = '商城')