<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper>
		<!-- 查询任务列表 -->
		<select id="selectAssignmentNameList">		
		SELECT
		  an.id id,
		  an.assignment_name assignment_name,
		  ds.sysname	 datasystem_name,
		  an.create_user,
		  an.create_date
		FROM
			t_core_assignment_name an,
			t_core_datasystem ds
		WHERE
			an.datasystem_id = ds.id
			and an.assignment_name like (CONCAT('%',:tname, '%')) order by an.create_date desc
		</select>		






</mapper>

