Skip to main content
Question

How to link two tables through a shared attribute?

  • August 26, 2020
  • 1 reply
  • 5 views

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?

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

redgeographics
Celebrity
Forum|alt.badge.img+59
  • Celebrity
  • 3700 replies
  • August 27, 2020

Check out the FeatureMerger and FeatureJoiner. Since it's feasible there's more than one piece of furniture per room you'll need to look at the list generation option.