create proc p1
@island_name varchar(20)
as
begin
select c.*
from city c
left join province a on a.province_id = c.province_id
left join country b on a.country_id = b.country_id
left join island d on d.island_id = b.island_id
where d.island_name = @island_name
end
create proc p2
@city_name varchar(20)
as
begin
select d.*
from island d
left join country b on d.island_id = b.island_id
left join province a on a.country_id = b.country_id
left join city c on a.province_id = c.province_id
where c.island_name = @city_name
end
@island_name varchar(20)
as
begin
select c.*
from city c
left join province a on a.province_id = c.province_id
left join country b on a.country_id = b.country_id
left join island d on d.island_id = b.island_id
where d.island_name = @island_name
end
create proc p2
@city_name varchar(20)
as
begin
select d.*
from island d
left join country b on d.island_id = b.island_id
left join province a on a.country_id = b.country_id
left join city c on a.province_id = c.province_id
where c.island_name = @city_name
end
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货