Early Access: The content on this website is provided for informational purposes only in connection with pre-General Availability Qlik Products.
All content is subject to change and is provided without warranty.
跳到主要内容

Create relationship

CREATE RELATIONSHIPDirect Query 应用程序数据模型中指定新的表和列关系。

CREATE RELATIONSHIP 只能在 Direct Query 应用程序中使用。它前面必须有 section directquery 部分。

语法:  

CREATE RELATIONSHIP (OUTER|INNER) JOINED] TableName, [(OUTER|INNER) JOINED] TableName ON ConditionExpression ;

信息注释

如果未指定表的 outer|inner joined 限定符,则默认为 inner joined

信息注释

对于 TableName,可以使用带引号的名称引用。例如,( IDENTIFIER | LITERAL_STRING | LITERAL_FIELD | LITERAL_NUMBER))

示例:  

CREATE RELATIONSHIP BETWEEN T1,T2 ON A = C;
CREATE RELATIONSHIP
BETWEEN OUTER JOINED T2, INNER JOINED T3
ON (D = E or (D is null and E is null));

本页面有帮助吗?

如果您发现此页面或其内容有任何问题 – 打字错误、遗漏步骤或技术错误 – 请告诉我们如何改进!