sql - Can I concatenate certain fields of a table in a multitable SELECT in MYSQL? -

i have table users, other table user experiences , other jobs (and more). want select users applied job new field formed concatenation of experiences of user, that:

select users.*,jobs.id, jobs.name users left join users.id = users_jobs.userid left join jobs.id = users_jobs.jobid left join users.id = user_experiences.userid 

i need add field select experiences concatenated of each user. trying group_concatenate returns me row.

any idea please?

not sure understood question correctly, here attempt :

select      users.*,     jobs.id,      jobs.name,     group_concat(user_experiences.the_field_you_want_to_concatenate) concatenated_field users left join users.id = users_jobs.userid left join jobs.id = users_jobs.jobid left join users.id = user_experiences.userid group       users.*,      jobs.id,      jobs.name;