Problem with query on sqlsrv

@renatoribeiro,

You should be able to write your query in such a way that if there is no value it still has a column name.  Which columns are you having issues with?  If you are using MySQL all you have to do is ... https://www.w3schools.com/sql/sql_alias.asp

Hi,
We recived this query by other software, only get the same and use. We don't have control of that.
We know that, but is impossible for me manage this.