Skip to Content
author's profile photo Former Member
Former Member

WebI combine query

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 08, 2011 at 06:15 PM

    the intersecion query is working

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 09, 2011 at 08:14 PM

    Some databases do not support all of the set operations (Union, Intersection, Minus) hence Web Intelligence will run multiple queries and to the operation locally. If the database supports the operation then it will appear in the SQL and be done on the server instead.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.