Select Rows Based On Foreign Key In One-To-Many Relationships In SQL
I have a posts
table and users
table. And posts
table has a column for author_id
(foreign key). This is clearly an example of a One-To-Many relationship. I want to get all posts written by a specific user, say the one with ID 9.