Join Application Tables with External Database Tables

Hello - I have a SQL data adapter that connects to an external database for data loads, dashboards, etc. Is it possible in the query to join these external tables to tables in the Application datab...