Hello
i am tring to create a combine query in Webi, i want to see something like
select table1.column1
from table1
where type = 1
intersection
select table2.column1
where type =2
however, when i use combine query -> intersection and look at the sql code, it only shows something like
select table1.column1
from table1
where type = 1
select table2.column1
where type =2
without "Intersecion" is that right?
if i change to Union, i can see "UNION" in the sql code, but why intersecion and mius are not in the sql code?
thanks