findTestDtoListByNameSql.sql

SELECT
	 a.test_id,
	 a.test_name,
	 b.test_type_name
FROM
	t_test a
	INNER JOIN m_test_type b
	ON a.test_type_id = b.test_type_id
WHERE
	a.test_name LIKE /*testName*/'S%'
ORDER BY a.test_id DESC