mysql多表查询
时间：2021-07-01 10:21:17
帮助过：22人阅读
area
from areas
where cityid
=(
select cityid
from cities
where city
like ‘杭州%‘)
and id
!=(
select min(id)
from areas
where cityid
=(
select cityid
from cities
where city
like ‘杭州%‘));
select area
from areas
where cityid
=(
select cityid
from cities
where id
=(
select min(id)
from cities
where provinceid
=(
select provinceid
from provinces
where province
like ‘上海%‘)));
mysql多表查询
标签：rom and div 多表查询 多表 mysql sql pre logs
