select * from 1表 inner join 2表 on 1表.字段=2表.字段
select * from areas a1 inner join areas a2 on a1.aid=a2.pid where a1.atitle='河南省'
select * from areas a1 left join areas a2 on a1.aid=a2.pid where a1.atitle='河南省'
select * from areas a1 left join areas a2 on a1.aid=a2.pid left join areas a3 on a2.aid=a3.pid where a1.atitle='河南省'
充当字查询的语句需要括号括起来(运算优先级括号最高)
select avg(price) from goods
select * from goods where price > (select avg(price) from goods)