SQL with union all

[DavidW]

Hello,

I am trying to use NAB to create statistics for one customer and I have a complicated SQL that I can't get to work.
Single parts are processed but as soon as I use UNION ALL I get the error:

„Compound/union statement columns must all have the same identifier."

I then tried a simple example with the democmast and also here I get the same error as soon as the SELECT Columns are different.

[FONT=Calibri][FONT=Arial][COLOR=#004075]select cusno, cname from democmast[/COLOR][/FONT][/FONT]
[FONT=Calibri][FONT=Arial][COLOR=#004075]union all[/COLOR][/FONT][/FONT]
[FONT=Calibri][FONT=Arial][COLOR=#004075]select cname, czip from democmast[/COLOR][/FONT][/FONT]

maybe someone has an idea or solution

[robert.swanson]

Hi David,

I think you just need to ensure the column names in each of the successive UNION clauses are identical for the NAB SQL logic. So insert an alias ("AS xxxx") wherever necessary to ensure all the column names match, i.e...

select cusno, cname [B]as name[/B], caddr1 [B]as addr [/B]from democmast
union all
select cusno, ccountry [B]as name[/B], caddr2 [B]as addr[/B] from democmast