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
FROM
bak_i3gy7_sv_apptpro3_requests r, bak_i3gy7_sv_apptpro3_udfvalues u
WHERE r.id_requests = u.request_id


Error

SQL query: Documentation

SELECT `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
FROM
bak_i3gy7_sv_apptpro3_requests r, bak_i3gy7_sv_apptpro3_udfvalues u
WHERE r.id_requests = u.request_id LIMIT 0, 25

MySQL said: Documentation
#1054 - Unknown column 'r.phone' in 'field list'