I would like to reverse some column during the UNION ALL in the Custom SQL.
I work with a mysql database.
I tried to change the alias and it seems that it doesn't work.... Is there a way to do what I try to do ?
For example I would like to reverse :
Thank you very much
The order of the fields in the UNION is dependant on the ordering in the query.
If I'm understanding correctly, you just need something like this:
SELECT ID, NOM, PRENOM
SELECT ID, PRENOM, NOM
Retrieving data ...