Aqua Data Studio 15.0.0-dev-57
Build #: 35326
Built on: 2013-Dec-23 01:24:49 PM
O.S. : Windows 8.1(64 bit)
Database: MS Excel
Steps to Reproduce :
1]Go to database tree node of MS Excel.
2]Connect and Expand tree node of MS Excel.
3]Right click on MS Excel database, Click on Query Builder option.
4]Query Builder window opens with "Add Table" window.
5]Select Database and Schema from database and Schema drop down list respectively, Select table from List of Table in Tables pane and Click on "Add and Close" button.
6]Click on "Filters" icon and check option "Auto join on foreign key".
Here "Auto join on foreign key" checkbox should be disable as we can select only one table in MS Excel database. There is no join support for MS Excel database.
We can do this in the new query builder