MySQL Forums
Forum List  »  Newbie

help with query multipole items in column
Posted by: Steve Klund
Date: January 13, 2022 07:45PM

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 AS PO_Name, 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.

Options: ReplyQuote

Written By
help with query multipole items in column
January 13, 2022 07:45PM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.