I have a data warehouse with a One-To-Many relationship:
"Fact" table contains: Product_Group_ID "Product_Bridge" table contains: Product_Group_ID, Product_ID "Product" table contains: Product_ID, Product_Name, other product attributes..
I've inserted the data into the relevant tables, but how can I query the database and retrieve all products from a product group in the one row result? I've never used a bridge table before and could not find any decent/helpful examples online for how to actually query between the bridge/fact/dimensions.
i.e. the desired result would look like:
product_group_ID product_ID product_name product_ID_1 product_name1 product_ID_n product_name_n
Any suggestions would be greatly appreciated.