SQL
Join Multiple Tables for Many-to-Many Relationships
Discover how to retrieve data from three tables involved in a many-to-many relationship using JOIN clauses to link users, roles, and a junction table.
SELECT u.username, r.role_name
FROM users u
JOIN user_roles ur ON u.id = ur.user_id
JOIN roles r ON ur.role_id = r.id
WHERE u.status = 'active';
How it works: This query demonstrates how to join three tables to resolve a many-to-many relationship. It connects the `users` table to the `roles` table via the `user_roles` junction table, linking records based on their respective foreign keys. The result shows usernames and their associated role names for all active users.