SQL三表联合查询

2019独角兽企业重金招聘Python工程师标准>>>

通过id选出line表中的id，pnt表中的name和blist表中的value.

SELECT  a.id AS 编号, b.name AS 名称, c.value AS 高程
FROM line AS a INNER JOIN pnt AS b
 ON a.id = b.pointid
INNER JOIN blist AS c ON b.pointid = c.bfpcode;

line:

转载于:https://my.oschina.net/u/266531/blog/470013