findTestDtoListByNameSql.sql 196 Bytes
Newer Older
Kim Gyeongeun committed
1 2 3 4 5 6 7 8 9 10 11
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