4.3 - Against two Subject Areas (Multiple Subject Area)

In the 10g version, the GUI of Answer is not able to provide a wizard to create a SQL (answer) against multiple subject with the JOIN clause, you have to create it manually and past it in the advanced tab.

4.3.1 - BI Server Log

In the log, you can see that because the two subject area are made on the top of the same data source, the query compiler create and send only one Physical Sql (part “Sending query to database named orcl SH”).