SELECT 
	ca.case_id AS case_id,
	CONCAT('',ca.case_title,'') AS case_name,
	cust.serial_num AS serial_num
FROM
	cases ca,	
	case_custom_fields cust,
WHERE 
	cust.case_id=ca.case_id