# Create relationship

CREATE RELATIONSHIP 在 Direct 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 RELATIONSHIPBETWEEN OUTER JOINED T2, INNER JOINED T3ON (D = E or (D is null and E is null));
```