select last_name,first_name,concat(date_of_birth,'-',month_of_birth,'-',year_of_birth) as DOB, dataField from measurements,demographic where measurements.demographicNo = demographic.demographic_no and type = '{type}' and dataField like '{keyvals}%'; select distinct type,typeDisplayName from measurementType where validation =7; Yes No Nonset