String sql = "select DISTINCT T.SEGMENTID ,S.SEGMENT_NAME,R.ROAD_NAME " +
"from DIM_BAYONET_DETECTOR t ,DIM_SEGMENT S ,DIM_ROADWAY R " +
"from DIM_BAYONET_DETECTOR t ,DIM_SEGMENT S ,DIM_ROADWAY R " +
"WHERE T.SEGMENTID = S.SEGMENTID AND S.ROADID = R.ROADID";
希望对大家有用,关于内联,外联,左联,右联可以再查查其他文章,不好意思啦。。。