SELECT `r.name`,`r.phone`,`r.email`,`r.resource`,`r.startdate`,`r.starttime`,`r.endtime`,'u.udf_value'
CASE u.udf_id
WHEN 1 THEN 'Comments'
WHEN 2 THEN 'OPUSid'
WHEN 3 THEN 'Offender'
ELSE 'blank'
END as UDFvalue
FROM
bak_i3gy7_sv_apptpro3_requests r, bak_i3gy7_sv_apptpro3_udfvalues u
WHERE r.id_requests = u.request_id


Auto comment in phpmyadmin:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CASE u.udf_id
WHEN 1 THEN 'Comments'
WHEN 2 THEN 'OPUSid'
WHEN 3 THEN 'Offend' at line 2