SELECT sde2.sde.STREETCL_ARC.OBJECTID, sde2.sde.STREETCL_ARC.Shape, sde2.sde.STREETCL_ARC.SEG_ID, LTRIM(sde2.sde.STREETCL_ARC.PRE_DIR +' ' + sde2.sde.STREETCL_ARC.ST_NAME +' ' + sde2.sde.STREETCL_ARC.ST_TYPE) AS STREETNAME, sde2.sde.STREETCL_ARC.ST_CODE, sde2.sde.STREETCL_ARC.ONEWAY, sde2.sde.STREETCL_ARC.CLASS, sde2.sde.BIKE_NETWORK_TBL_NEW.TYPE FROM sde2.sde.STREETCL_ARC RIGHT OUTER JOIN sde2.sde.BIKE_NETWORK_TBL_NEW ON sde2.sde.STREETCL_ARC.seg_id = sde2.sde.BIKE_NETWORK_TBL_NEW.SEG_ID
Solved! Go to Solution.
SELECT sde2.sde.STREETCL_ARC.OBJECTID, sde2.sde.STREETCL_ARC.Shape, sde2.sde.STREETCL_ARC.SEG_ID, LTRIM(sde2.sde.STREETCL_ARC.PRE_DIR +' ' + sde2.sde.STREETCL_ARC.ST_NAME +' ' + sde2.sde.STREETCL_ARC.ST_TYPE) AS STREETNAME, sde2.sde.STREETCL_ARC.ST_CODE, sde2.sde.STREETCL_ARC.ONEWAY, sde2.sde.STREETCL_ARC.CLASS, sde2.sde.BIKE_NETWORK_TBL_NEW.TYPE FROM sde2.sde.STREETCL_ARC RIGHT OUTER JOIN sde2.sde.BIKE_NETWORK_TBL_NEW ON sde2.sde.STREETCL_ARC.seg_id = sde2.sde.BIKE_NETWORK_TBL_NEW.SEG_ID
SELECT sde2.sde.STREETCL_ARC.OBJECTID, sde2.sde.STREETCL_ARC.Shape, sde2.sde.STREETCL_ARC.SEG_ID, LTRIM(sde2.sde.STREETCL_ARC.PRE_DIR +' ' + sde2.sde.STREETCL_ARC.ST_NAME +' ' + sde2.sde.STREETCL_ARC.ST_TYPE) AS STREETNAME, sde2.sde.STREETCL_ARC.ST_CODE, sde2.sde.STREETCL_ARC.ONEWAY, sde2.sde.STREETCL_ARC.CLASS, sde2.sde.BIKE_NETWORK_TBL_NEW.TYPE FROM sde2.sde.STREETCL_ARC RIGHT OUTER JOIN sde2.sde.BIKE_NETWORK_TBL_NEW ON sde2.sde.STREETCL_ARC.seg_id = sde2.sde.BIKE_NETWORK_TBL_NEW.SEG_ID