> From: "Mogens Melander" <mogens@stripped>
>
> So, I got a little further with my problem. I found an article
> on:
>
> http://stackoverflow.com/questions/3122424/dynamic-mysql-query-view-for-crosstab
>
> Describing how to do the dynamic generation of SQL statements. That's
> all good, kind of. The resulting SQL looks like this:
>
> SELECT main.code
> , IF(iconstandardrel.icon = 4,1,0) AS 'internationalt_produkt.eps'
> , IF(iconstandardrel.icon = 3,1,0) AS 'god_vaerdi.eps'
> , IF(iconstandardrel.icon = 2,1,0) AS 'for_miljoeets_skyld.eps'
> , IF(iconstandardrel.icon = 1,1,0) AS 'ergonomisk_produkt.eps'
> , IF(iconstandardrel.icon = 6,1,0) AS 'saml_selv.eps'
> , IF(iconstandardrel.icon = 12,1,0) AS 'brandfarlig.eps'
> FROM iconstandardrel
> JOIN main ON main.code = iconstandardrel.code
> JOIN iconstandard ON iconstandard.id = iconstandardrel.icon
> ORDER BY iconstandardrel.code;
>
> Which produces results like:
>
> 101577, 1, 0, 0, 0, 0, 0
> 101679, 0, 1, 0, 0, 0, 0
> 101679, 1, 0, 0, 0, 0, 0
> 101681, 1, 0, 0, 0, 0, 0
> 101748, 0, 1, 0, 0, 0, 0
> 101748, 1, 0, 0, 0, 0, 0
>
> But I would like to have One line per code:
>
> 101577, 1, 0, 0, 0, 0, 0
> 101679, 1, 1, 0, 0, 0, 0
> 101681, 1, 0, 0, 0, 0, 0
> 101748, 1, 1, 0, 0, 0, 0
>
> Is it possible to achieve this in pure SQL ?
I think you need GROUP BY main.code.
----------------
:::: If you worry about what might be, and wonder what might have been, you will ignore
what is. -- Robert Anthony
:::: Jan Steinman, EcoReality Co-op ::::
