MySql : fill a column thanks to a IF condition ? (see example inside ;) )

Issue

I have a database table that looks like this:

I need to get:

Is there any possibility, with IF condition, to fill the right column?

I don’t really know if I’d be possible to do it…

Thanks you for your precious help 🙂

edit : I tried the Forpas suggestion, but I just add

but I have not more result 🙁 see here

Solution

You need conditional aggregation:

SELECT Name, Town,
       MAX(CASE WHEN Type = 'Big' AND Brand = 'Sony' THEN Ref END) Big_Sony,
       MAX(CASE WHEN Type = 'Big' AND Brand = 'Nokia' THEN Ref END) Big_Nokia,
       MAX(CASE WHEN Type = 'Little' AND Brand = 'Sony' THEN Ref END) Little_Sony,
       MAX(CASE WHEN Type = 'Little' AND Brand = 'Nokia' THEN Ref END) Little_Nokia
FROM tablename
GROUP BY Name, Town 

See the demo.
Results:

Answered By – forpas

This Answer collected from stackoverflow, is licensed under cc by-sa 2.5 , cc by-sa 3.0 and cc by-sa 4.0