-3
Good morning gentlemen(s) I have the following problem: [Edited]
As can be seen in the image above, there are several fields with the same result (minus the "desric" column). What I need is that in addition to grouping the identical results, the desric column would look like this: "Domestic animals, noise";
Something like this:
|DESRIC|MEDPPIC|CONDFEPIC|USOIEPIC|PRZVEPIC|PERTEPIC|HIGEPIC|
|DOMESTIC ANIMALS|S|N|S|S|S|S|S|S|
|DOMESTIC ANIMALS, NOISE|S|S|S|S|S|S|S|S|
Sorry for the formatting, but I believe I can understand.
Follow my sql image [Edited]
----EDIT----
I ended up finding the command LIST(), which does exactly what I want, but I would still like to know from which version this function has been implemented.
I’ll test it here and get back to you.
– Edenilson
Friend, it worked for me here but I had to make some small adaptations. I thank you for your help. Tomorrow I will post here as answer the final version, so that if more people need.
– Edenilson
The ideal is to migrate customers who are in the older version to new and use the "list". But in the worst case you can do it that way.
– Rodrigo Moreira
Sure the ideal is to update, but the problem is that these customers have very large database and any little problem of incompatibility generates a phenomenal headache.
– Edenilson