how to bring in data from a database by using data in another database

I would simply use power query - use import to pull the tables from both databases and then use merge (depending on the needs I would pick the join I need) by the key column. Make sure you are pulling only the columns and rows you need before the merge.