SubQuery same table

[T Jor]

Hi,
I have a table with these field:

Table: wp_contacts_submits

wp_contactic_submits.form_name;
wp_contactic_submits.field_name,
wp_contactic_submits.Image,
wp_contactic_submits.field_value,


running sql / working fine
SELECT DISTINCT wp_contactic_submits.field_name, wp_contactic_submits.Image, wp_contactic_submits.form_name, Sum(wp_contactic_submits.field_value) AS SUM
FROM `wp_contactic_submits`
WHERE field_name IN('Oliver','Jeppe') and form_name IN('Barcelona','Liverpool') GROUP BY wp_contactic_submits.field_name


Result:
Field_name / image / form_name / SUM
Oliver / photo1 / Barcelona / 38
Jeppe / photo2 /Barcelona / 40
Oliver / photo1 / Liverpool / 20
Jeppe / photo2 /Liverpool / 17



Instead I will like to have a output like:

Field_name / image / Barcelona / Liverpool / total sum
Oliver / photo1 / 38 / 20 / 58
Jeppe /Photo2 / 40 / 17 / 57

Anybody can help me :-) ?
Thanks
BR Thomas