We are trying to join two tables in Winshuttle Query and get an error message that reads "The table/s can not be added to the Query Builder as you do not have admin privileges to create joins on Cluster/ Pool / View Tables 0 tables(s) added out of selected 1 tables(s)".
Query 10.x with a Connect license
You will need to enable this setting/checkbox under the Query Admin Default section within the software. Open Query and go to Tools > Options > Admin Defaults.
**Note: You may need to launch Query initially as an administrator (right click on the icon and select "run as administrator". Also, the default password for the Admin Defaults prompt is "queryshuttleadmin".