Filter Query Layer with Field from a Table in a Geodatabase

Question

ArcGIS Pro 3.0.2

Is it possible to use the column of table in my Project to filter a query using the make query layer tool?

I have a table of events in my project with a location_id column, and I want to left join in my Locations table by location_id from different database. I want to only pull in locations that exist inside of my event table in the project so that I'm not loading the entire locations table.

Something like:

SELECT *
FROM location_tbl
WHERE location_tbl.id IN (<id_column_of_table_in_my_Pro_Project>)

I see this doc here about query parameters, but I don't see anything about passing in a column from an existing table as a parameter.

The data comes from two different SDE connection files to an MS SQL Server database.

Answer 1

you can do a join over two databases if the are on the same MS SQL-Server, ex.

SELECT 
tb_1.*,
tb_2.*
FROM [database_1].[table_schema].[table_name_1] tb_1
JOIN [database_2].[table_schema].[table_name_2] tb_2 ON tb_1.id = tb_2.id

you need the permission to access the database and the specified table