how to use CONCAT inside a SELECT

Code MySQL:

---

SELECT t_request_detail.REQ_CO, t_request_detail.EU_NAME, m_model.MODEL_NA, t_request_detail.QTY_DEF, CONCAT(t_request_detail.SVC_Y, " years, ", t_request_detail.SVC_M, " months")
FROM t_request_detail 
 LEFT JOIN m_model ON t_request_detail.MODEL_CO = m_model.MODEL_CO
)

---

Can anyone explain why the use of CONCAT above causes an error?

Not seeing the data I'm going to guess it's a LEFT JOIN issue as there seems to be no syntax error with your SQL statement. Do you have to use a LEFT JOIN or can you try an natural join?

What's the error?

there is no error, although single quotes to delimit strings would be better, since that would be standard sql

i'm guessing this sql statement is inside doubleqoutes in a php assignment

$sql = "SELECT....

that would produce an error

i was misled by the sql error, after simplifying the query i found that one of the col names was wrong.