u/DrewG4444

I’ve tried a few different methods but I am struggling to figure out what is the best way to go about it.

I have NPIs and their information, like address, PDEs, names, facility, etc

I want it so that I can use the information to join with additional tables.

Like in SQL it would be
Left join or sometimes inner join