Help with Multiple Tables

Hi everyone,

I have a doubt with the image I have attached below. I need to know how to attach DIM_Manufacturers to the main table which is FACT_TRANSACTIONS?

Any help would be greatly appreciated! :slight_smile:

I think you can do two joins and filter out whatever you need?

For reference:

https://www.codecademy.com/learn/learn-sql/modules/learn-sql-multiple-tables/cheatsheet