Page Comparison

{anchor:top}
h2. Overview
{styleclass: Class=topLink}[top|#top]{styleclass}
Yellowfin has advanced sub query functionality which allows the user to query more than one view (and sometimes data source) at the same time and combine the results in a single report. This can multiple data sources to be treated as one virtual database, accessing them through a single report.

Both *Append* and *Union* sub queries allow you to bring together the results from two separate sources and display them together in the one report or chart. *Minus* and *Intersect* sub queries only allow the selection of different views, rather than sources.


{anchor:top}
h2. Advanced Append and Union Sub Queries
{styleclass: Class=topLink}[top|#top]{styleclass}
{section}
{column:width=30%}
*1.* In order to create an *Advanced Sub Query*, rather than a Basic one you need to click on the + *Sub Query* link

*2.* You then need to select either *Union* or *Append*.

*3.* Select a *Data Source* and a *View*.

*4.* Click on the Submit link and proceed as normal. You will notice that new data fields have been loaded on the left hand side of the window, corresponding to the view you just selected.	
{column}
{column:width=70%}
!26append.png!
{column}
{section}
bq. See [Sub Queries|Sub Queriesサブクエリー] for more information.


{anchor:top}
h2. Advanced Minus and Intersect Sub Queries
{styleclass: Class=topLink}[top|#top]{styleclass}
{section}
{column:width=30%}
*1.* In order to create an *Advanced Sub Query*, rather than a Basic one you need to click on the + *Sub Query* link

*2.* You then need to select either *Minus* or *Intersect*.

*3.* Select a *View*.

*4.* Click on the Submit link and proceed as normal. You will notice that new data fields have been loaded on the left hand side of the window, corresponding to the view you just selected.	
{column}
{column:width=70%}
!27minus.png!
{column}
{section}
bq. See [Sub Queries|Sub Queriesサブクエリー] for more information.
\\
{horizontalrule}
{styleclass: Class=topLink}[top|#top]{styleclass}