sql-server - 没有为 'sp' 的第 1 列指定列名

Question

我有以下查询:

SELECT s."Description",
sp.*
FROM "Supplier" as s
OUTER APPLY (
    SELECT p."Id", p."Description", p."Price"
    FROM "Products" as p
    WHERE p."SupplierId" = s."Id"
    FOR JSON auto 
) as sp

我正在尝试根据 OUTER APPLY 构建 json 数组结果但我卡在这里是因为有错误 No column name was specified for column 1 of 'sp'.我在stackoverflow上发现了类似的问题，但没有外部应用的例子。

你能解释一下这个查询有什么问题吗？

Answer 1

您只需要添加一个列别名:

SELECT 
    s."Description",
    sp.*
FROM "Supplier" as s
OUTER APPLY (
    SELECT p."Id", p."Description", p."Price"
    FROM "Products" as p
    WHERE p."SupplierId" = s."Id"
    FOR JSON auto 
) as sp(json)