mysql - select multiple values from same column -

select b_lastname, b_firstname, cscart_profile_fields_data.value vat cscart_user_profiles inner join cscart_profile_fields_data on cscart_profile_fields_data.object_id = cscart_user_profiles.user_id cscart_profile_fields_data.field_id =64 , cscart_profile_fields_data.object_type = 'p' 

i using code above, in order values cscart_user_profiles table cscart_profile_fields_data table , value field. different values value field in same query, changing field_id

if understand question:

select b_lastname, b_firstname, cscart_profile_fields_data.value vat cscart_user_profiles inner join cscart_profile_fields_data on cscart_profile_fields_data.object_id = cscart_user_profiles.user_id cscart_profile_fields_data.field_id in (64, ...) , cscart_profile_fields_data.object_type = 'p' 

this quere return many rows parameters in in condition

or:

select b_lastname, b_firstname, group_concat(cscart_profile_fields_data.value separator ';') vat cscart_user_profiles inner join cscart_profile_fields_data on cscart_profile_fields_data.object_id = cscart_user_profiles.user_id cscart_profile_fields_data.field_id in (64, ...) , cscart_profile_fields_data.object_type = 'p' group b_lastname, b_firstname 

above query return 1 row many values in vat column separated ; character (like csv file)