No database selected
select
	a.NAME,
	a.TIME1,
	a.TIME2,
	a.DATE,
	a.PICKUP,
	c.ROMAN,
	c.AGE
FROM `ATT` a
LEFT JOIN `CP_LIST` c ON a.NAME = c.NAME
WHERE a.DATE = "20120517"
AND a.NAME = c.NAME
ORDER BY a.TIME1 , a.TIME2 , c.SORT