help with query multipole items in column

[Steve Klund]

hello
Thank you in advance for any help.
I need to provide a report using (in part) a table named 'udfvalues'
One column has multiple items listed and I cannot figure out how to build the query.
example data by column:

id udf_id request_id udf_value

74 2 25 Hary
75 3 25 1569843
77 2 26 George
78 3 26 1625701
80 2 27 Sherry
81 3 27 1340979

The udf_id equates 2 = name
3 = client number

I can only select one due to not knowing how to add both.

here is the portion of the query if anyone can help


SELECT a.name AS PO_Name, a.email AS PO_Email, a.startdate, a.starttime, a.request_status,

CASE a.resource
WHEN 1 THEN 'office1'
.......

END AS Office,
-- b.udf_value AS Offender_Name
b.udf_value AS OPUSid

FROM v6z59_sv_apptpro3_requests a, v6z59_sv_apptpro3_udfvalues b
WHERE a.id_requests = b.request_id
AND b.udf_id = '3'
-- AND Office = 'Johnston'
AND a.startdate >= '2021-10-01 00:00:00' and a.startdate <= '2021`127-30 23:59:59'
Order BY Office ASC


Thank you for any suggestions.