三表联合查询的sql语句

String sql = "select DISTINCT T.SEGMENTID ,S.SEGMENT_NAME,R.ROAD_NAME " +
"from DIM_BAYONET_DETECTOR t ,DIM_SEGMENT S ,DIM_ROADWAY R " +

"WHERE T.SEGMENTID = S.SEGMENTID AND S.ROADID = R.ROADID";

希望对大家有用，关于内联，外联，左联，右联可以再查查其他文章，不好意思啦。。。