sql - Query for retrieving data from a bridging table of many to many relationship

Question

Closed. This question needs to be more focused. It is not currently accepting answers. question from:https://stackoverflow.com/questions/65868192/query-for-retrieving-data-from-a-bridging-table-of-many-to-many-relationship

Answer 1

So you're trying to link e.g. Case to Referral via the association table Case_Referral? So what's the issue you're facing?

This is a pretty simple, straightforward SQL statement - SELECT from Case, join on Case_Referral via the case_id key, then join to Referral using the referral_id, and specify which columns from each table you need:

SELECT
    c.user_name, c.date as CaseDate, c.priority, c.case_status,
    r.date AS ReferralDate, r.referral_name
FROM
    dbo.Case c
INNER JOIN
    dbo.Case_Referral cr ON c.case_ID = cr.case_ID
INNER JOIN
    dbo.Referral r ON cr.referral_ID = r.referral_ID

So what is the issue / problem you're not understanding?

You can use the same "technique" to join the other m:n relationships.