I have two tables: Room and Furniture. In the Room table, I have room_id, and furnitures attributes, and in the Furiture table, I have room_id and furniture_name...etc. How to link these two tables through room_id, so each room will have a list of furnitures that belong to that room?
Thanks for your input!