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.
maybe someone has an idea or solution
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.
Code:
select cusno, cname from democmast union all select cname, czip from democmast
Comment