尝试学习沙箱中的查询语法(https://www.documentdb.com/sql/demo https://www.documentdb.com/sql/demo )
SELECT food.id FROM food JOIN t in food.tags WHERE t.name = "oil"
这可行,但是如果我想获取整个文档怎么办,所以我尝试了
SELECT food.* FROM food JOIN t in food.tags WHERE t.name = "oil"
and
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"
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)