left join案例

		String sql="select NVL(rci.rci_id,rdi.rdi_id) as resId,NVL(rci.rci_name,rdi.rdi_name) as resName," +
				"NVL(rci.rci_type,rdi.rdi_type) as channelDeviceType,iri.iri_index_type as resType," +
				"ivi.ivi_warn_grade as indexWarnGrade,ivi.ivi_warn_start_date as indexWarnStartDate," +
				"ivi.ivi_warn_lately_date as indexWarnLatelyDate,ivi.ivi_warn_content as indexWarnContent,ivi.ivi_repair_status as iviRepairStatus from index_value_info ivi  " +
				"left join index_res_info iri on ivi.iri_id=iri.iri_id " +
				"left join res_device_info rdi on iri.rdi_id=rdi.rdi_id " +
				"left join res_channel_info rci on iri.rci_id=rci.rci_id "+
				"where ivi.ivi_warn_grade!='0'";
		if(warnType!=null&&!warnType.trim().equals("")){
			sql+=" and ivi.ivi_warn_grade='"+warnType+"'";
		}
		if(resType!=null&&!resType.trim().equals("")){
			sql+=" and iri.iri_index_type='"+resType+"'";
		}
		if(resName!=null&&!resName.trim().equals("")){
			sql+=" and (rci.rci_name like '%"+resName+"%' or rdi.rdi_name like '%"+resName+"%')";
		}
		if(repairedState!=null&&!repairedState.trim().equals("")){
			sql+=" and ivi.ivi_repair_status='"+repairedState+"'";
		}
		if(startDateStr!=null&&!startDateStr.trim().equals("")){
			sql+=" and to_date(to_char(ivi.ivi_warn_lately_date,'yyyy-mm-dd'),'yyyy-mm-dd')>=to_date('"+startDateStr+"','yyyy-mm-dd')";
		}
		if(endDateStr!=null&&!endDateStr.trim().equals("")){
			sql+=" and to_date(to_char(ivi.ivi_warn_lately_date,'yyyy-mm-dd'),'yyyy-mm-dd')<=to_date('"+endDateStr+"','yyyy-mm-dd')";
		}
		sql+=" order by ivi.ivi_warn_lately_date desc,ivi.ivi_warn_grade desc";