how to use CONCAT inside a SELECT

[mameha]

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?

[falsealarm]

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?

[guido2004]

What's the error?

[r937]

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

[mameha]

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