Back
Relationship / left join on key
Does anyone know how to crrate a relationship on a key. I have 2 tables. I want a many to one relation. Where each post has one username. Each username can have many posts. When I create the relationship and test it by creating a document my options are only the ids of the rows. I want to use the userid to get the username(unique). How can this be done?
TL;DR
Developers are looking to create a many-to-one relationship in a database using a unique key. They want to use the userID to retrieve the unique username instead of just the row IDs. This can be achieved by setting up a left join on the key that connects the two tables.