用联合查询INNER JOIN语句,如把一个表的province_id变成省份名称

如下

SELECT c.id,city,p.province FROM city AS c
INNER JOIN provice AS p
ON c.pid=p.id;