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

最初发表于: 2019-04-26 15:31:19

如下

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