mysql多表查询
标签：rom and div 多表查询 多表 mysql sql pre logs
mysql多表查询
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 ‘上海%‘)));