To connect to another database as well as table, you'll need to add this into the 'Join' field under advanced:dbname.owner.tablenameIf the name of the database is 'YourDB' and the table is 'YourTable', it
might look like this:YourDB.dbo.YourTable
might look like this:YourDB.dbo.YourTable
select * from table1 join database2.dbo.talbe2 on ....