如何查找以下情况的联接查询

Question

I have two tables named branch and source. Table branch contains the columns b_id and b_name and table source contains columns s_name and b_code where each row contain multiple b_code separated by commas. I want result of with fields s_name and b_name.

Answer 1

The SQL will be something like this:

SELECT source.s_name, branch.b_id
FROM source
INNER JOIN branch ON source.b_code = branch.b_id
ORDER BY source.b_code

I'm using MS SQL and the query have not yet be tested. Let me know if the results are correct.