SELECT T.AREAPOINTID,
AREAPOINT,
SHAPETYPE,
LON,
LAT,
LON2,
LAT2,
POINTSTR,
STOPTIME,
LIMITTYPE,
STARTTIME,
ENDTIME
FROM T_AREAPOINT T
LEFT JOIN T_DRIVEROAD_AREAPOINT DA ON T.AREAPOINTID = DA.AREAPOINTID
LEFT JOIN T_UNIT_AREAPOINT UA ON T.AREAPOINTID = UA.AREAPOINTID
WHERE T.AREAPOINTID = 181
左连接示例
最新推荐文章于 2021-02-03 05:10:16 发布