,TRUNCATE((SELECT DATEDIFF(CONCAT((DATE_FORMAT(v.datedsc,"%Y")-543),"-",DATE_FORMAT(v.datedsc,"%m-%d")), STR_TO_DATE(p.birthdate, '%Y-%m-%d'))/365),0) as 'อายุ ณ วันวินิจฉัย' INNER JOIN hos_pt p ON v.hn = p.hn,TRUNCATE((SELECT DATEDIFF(CONCAT((DATE_FORMAT(v.datedsc,"%Y")-543),"-",DATE_FORMAT(v.datedsc,"%m-%d")), STR_TO_DATE(p.birthdate, '%Y-%m-%d'))/365),0) as 'อายุ ณ วันวินิจฉัย' INNER JOIN hos_pt p ON v.hn = p.hn