无外键关联的2个表的查询
?
?
?
?
if(null!=level && !"".equals(level)){//有条件查询sql = "SELECT " +"E.ENUMID," +"E.role," +"E.PRI," +"E.DOMAIN," +"E.URL," +"P.PROVINCE_NAME," +"E.DISTINCT_ID," +"E.DESCRIPTION " +"FROM ENUM_INFO E, PROVINCE_INFO P " +"WHERE TO_NUMBER(SUBSTR(E.HOME_ID, 4, 3)) = P.PROVINCE_ID AND role='"+level+"' " +"UNION ALL " +"SELECT " +"E.ENUMID," +"E.role," +"E.PRI," +"E.DOMAIN,E.URL," +"'全国'," +"E.DISTINCT_ID," +"E.DESCRIPTION FROM ENUM_INFO E " +/*"WHERE E.role = 1 AND " +*/"WHERE role='"+level+"' AND e.home_id='"+SysConstants.FIRST_ENUM_HOMEID+"' " +"ORDER BY role ASC";}else{//无条件查询sql = "SELECT " +"E.ENUMID," +"E.role," +"E.PRI," +"E.DOMAIN," +"E.URL," +"P.PROVINCE_NAME," +"E.DISTINCT_ID," +"E.DESCRIPTION " +"FROM ENUM_INFO E, PROVINCE_INFO P " +"WHERE TO_NUMBER(SUBSTR(E.HOME_ID, 4, 3)) = P.PROVINCE_ID " +"UNION ALL " +"SELECT " +"E.ENUMID," +"E.role," +"E.PRI," +"E.DOMAIN,E.URL," +"'全国'," +"E.DISTINCT_ID," +"E.DESCRIPTION FROM ENUM_INFO E " +" WHERE " +/*"E.role='1' OR E.ROLE='2' " +" AND " +*/"e.home_id='"+SysConstants.FIRST_ENUM_HOMEID+"' " +"ORDER BY role ASC";}??
?
?