---
title: "GetJoinInfo"
slug: "getjoininfo"
updated: 2024-09-26T14:22:53Z
published: 2024-09-26T14:22:53Z
canonical: "docs.datajet.app/getjoininfo"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.datajet.app/llms.txt
> Use this file to discover all available pages before exploring further.

# GetJoinInfo

Get detailed join information for a project

| Key | Value(s) | Description |
| --- | --- | --- |
| method | "GetJoinInfo" | Get detailed join information for a project |

{Explanation}

```json
{
  "method": "GetJoinInfo"
}
```

```json
{
  "info": {
    "joins": [
      {
        "primaryTable": "sample_table",
        "primaryField": "first_name",
        "foreignTable": "03_HEADER_RAW",
        "foreignField": "first_name",
        "homePath": "",
        "primaryTotal": 1277427,
        "foreignTotal": 78180465,
        "primayResolved": 14182,
        "foreignResolved": 13255434,
        "primary": [
          "sample_table.first_name"
        ],
        "foreign": [
          "03_HEADER_RAW.first_name"
        ],
        "rootFolder": "",
        "fDataSets": [
          {
            "logic": "or",
            "name": "SubSet",
            "strict": true,
            "set": [
              {
                "logic": "or",
                "stype": "TABLE",
                "entity": "03_HEADER_RAW"
              },
              {
                "logic": "or",
                "stype": "INTRINSIC",
                "intrinsic": {
                  "function": "random%",
                  "params": [
                    "17",
                    "63833412390280"
                  ]
                }
              }
            ]
          }
        ],
        "layers": 1,
        "name": "sample_table_03_HEADER_RAW",
        "injected": false
      },
      {
        "primaryTable": "sample_table_2",
        "primaryField": "first_name",
        "foreignTable": "03_HEADER_RAW",
        "foreignField": "first_name",
        "homePath": "",
        "primaryTotal": 1277427,
        "foreignTotal": 78180465,
        "primayResolved": 13744,
        "foreignResolved": 77922376,
        "primary": [
          "sample_table_2.first_name"
        ],
        "foreign": [
          "03_HEADER_RAW.first_name"
        ],
        "rootFolder": "d:\\datajet_s\\dj-localhost\\LN_Vanilla\\",
        "fDataSets": [
          {}
        ],
        "layers": 1,
        "name": "sample_table_2_03_HEADER_RAW",
        "injected": false
      },
      {
        "primaryTable": "sample_table_3",
        "primaryField": "first_name",
        "foreignTable": "sample_table_2",
        "foreignField": "first_name",
        "homePath": "",
        "primaryTotal": 3752662,
        "foreignTotal": 1277427,
        "primayResolved": 13184,
        "foreignResolved": 1276784,
        "primary": [
          "sample_table_3.first_name"
        ],
        "foreign": [
          "sample_table_2.first_name"
        ],
        "rootFolder": "d:\\datajet_s\\dj-localhost\\LN_Vanilla\\",
        "fDataSets": [
          {}
        ],
        "layers": 1,
        "name": "sample_table_3_sample_table_2",
        "injected": false
      },
      {
        "primaryTable": "sample_table_3",
        "primaryField": "first_name",
        "foreignTable": "03_HEADER_RAW",
        "foreignField": "first_name",
        "homePath": "",
        "primaryTotal": 3752662,
        "foreignTotal": 78180465,
        "primayResolved": 16927,
        "foreignResolved": 78115920,
        "primary": [
          "sample_table_3.first_name"
        ],
        "foreign": [
          "03_HEADER_RAW.first_name"
        ],
        "rootFolder": "d:\\datajet_s\\dj-localhost\\LN_Vanilla\\",
        "fDataSets": [
          {}
        ],
        "layers": 1,
        "name": "sample_table_3_03_HEADER_RAW",
        "injected": false
      }
    ]
  },
  "executed": true,
  "errors": [],
  "millis": 3,
  "projectEpoch": 638629450376249996,
  "method": "GetJoinInfo",
  "exmillis": 4
}
```