Hello,
I have a very simple result set from this select:
select Name,PrimaryEducation,HighSchoolEducation,Weight,Height from Person
and I got this result set:
Name PrimaryEducation HighSchoolEducation Weight Height(cm)
Adam yes no 156 178
Mark no no 170 186
The problem is I want to give a common title for a set of columns, for example, I want to name PrimaryEducation and HighSchoolEducation as EDUCATION and Weight,Height as GENERAL INFO
I am looking for a report like this:
EDUCATION GENERAL INFO
Name PrimaryEducation HighSchoolEducation Weight Height(cm)
Adam yes no 156 178
Mark no no 170 186
I looked for all Mydbr command but I was not able to find a solution.
Any suggestions?