数据库：一张表中多个字段同时引用另一张表时

      SELECT * FROM dic

 

        SELECT * FROM info

 

 

SELECT info.id,info.province_id,info.county_id,A.name 名称1,B.name 名称2
FROM info,dic A,dic B where info.province_id=A.id and info.county_id=B.id

 

select
t1.*,
t2.name as 名称1,
t3.name as 名称2
FROM info AS t1
INNER JOIN dic AS t2 ON t1.province_id = t2.id
INNER JOIN dic AS t3 ON t1.county_id= t3.id