如何将一个表行联接为其他表列以用作动态值？

SELECT *
FROM (
    SELECT main_table_id, join_table_value
    FROM MainTable
    JOIN JoinTable ON MainTable.join_table_id = JoinTable.id
) AS subquery
PIVOT (
    MAX(join_table_value)
    FOR main_table_id IN (1, 2, 3, ...)
) AS pivot_table;

SELECT *
FROM (
    SELECT main_table_id, join_table_value
    FROM MainTable
    JOIN JoinTable ON MainTable.join_table_id = JoinTable.id
) AS subquery
PIVOT (
    MAX(join_table_value)
    FOR main_table_id IN ([1], [2], [3], ...)
) AS pivot_table;

SELECT *
FROM (
    SELECT main_table_id, join_table_value
    FROM MainTable
    JOIN JoinTable ON MainTable.join_table_id = JoinTable.id
)
PIVOT (
    MAX(join_table_value)
    FOR main_table_id IN (1, 2, 3, ...)
);