Skip to content
Start project
Back

Relationship / left join on key

  • 0
  • Databases
View on Discord
cryptobitez
21 Dec, 2024, 19:59

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.
Reply

Reply to this thread by joining our Discord

Reply on Discord

Recommended threads

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more