“"SELECT *"仅对单个输入集有效." [英] "'SELECT *' is only valid with a single input set."

问题描述

尝试在沙箱中学习查询语法( https://www.documentdb.com/sql/演示)

Trying to learn the query syntax in the sandbox ( https://www.documentdb.com/sql/demo )

SELECT food.id FROM food JOIN t in food.tags WHERE t.name = "oil"

这可行，但是如果我想获取整个文档怎么办，所以我尝试了

This works, but what if I want to get the entire document, so I tried

SELECT food.* FROM food JOIN t in food.tags  WHERE t.name = "oil"

和

SELECT * FROM food JOIN t in food.tags  WHERE t.name = "oil"

并得到错误:

{
  "errors": [
    {
      "severity": "Error",
      "location": {
        "start": 7,
        "end": 8
      },
      "code": "SC2040",
      "message": "'SELECT *' is only valid with a single input set."
    }
  ]
}

如何拿回整个文档?

推荐答案

您想要的是:

SELECT VALUE food FROM food JOIN t in food.tags WHERE t.name = "oil"

这篇关于“"SELECT *"仅对单个输入集有效."的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！