To summarize the advice for XML join queries, always cast join predicates to the type of the XML index that should be used.
总结一下关于XML连接查询的建议,通常将连接谓词转换为应使用的xml索引类型。
You can tell the type of join (INNER, RIGHT, or LEFT) by the details of the join operator.
可以根据连接操作符的细节判断连接的类型(INNER、RIGHT或LEFT)。
For customer type, join the column KTOKD from the E2KNA1M005 table with its corresponding supporting data in JLT_T077D, using KTOKD as the join key.
对于客户类型来说,在JLT_T077D上使用其相应的支持数据来联接来自E2KNA1M 005表的列ktokd,使用KTOKD作为联接键。
应用推荐