Skip to Content
0
Former Member
Dec 08, 2011 at 04:53 PM

WebI combine query

30 Views

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