Stay organized with collectionsSave and categorize content based on your preferences.
This page links to all the LookML parameters that are children of thejoinparameter. You can learn more about using joins on theWorking with joins in LookMLdocumentation page.
A join is what allows multipleviewsto be added to a singleExplore, allowing users to access and compare fields from various views at the same time. You declare the Explore and any desiredjoinparameters in amodel file.
Example usage
Hover over a parameter name to see a quick description; click it to jump to that page.
When a parameter can be set to one of several specific options, the default value is listed first.
If this join is included in the query, inserts conditions into the query'sWHEREclause that a user cannot change or remove for this Explore. (For BigQuery only)
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-07-22 UTC."],[],[],null,["# Join parameters\n\n\u003cbr /\u003e\n\nThis page links to all the LookML parameters that are children of the `join` parameter. You can learn more about using joins on the [Working with joins in LookML](/looker/docs/working-with-joins) documentation page.\n\nA join is what allows multiple [views](/looker/docs/reference/param-view) to be added to a single [Explore](/looker/docs/reference/param-explore), allowing users to access and compare fields from various views at the same time. You declare the Explore and any desired `join` parameters in a [model file](/looker/docs/reference/param-model).\n\nExample usage\n-------------\n\nHover over a parameter name to see a quick description; click it to jump to that page.\nWhen a parameter can be set to one of several specific options, the default value is listed first. \n\n```\n## STRUCTURAL PARAMETERS\n/looker/docs/reference/param-explore-explore: explore_name {\n # Desired Explore parameters (described on Explore Parameters page)\n\n /looker/docs/reference/param-explore-join: join_name {\n\n # DISPLAY PARAMETERS\n /looker/docs/reference/param-explore-join-view-label: \"desired label for the view\"\n\n # JOIN PARAMETERS\n /looker/docs/reference/param-explore-join-fields: [field_or_set, field_or_set, ...]\n /looker/docs/reference/param-explore-join-foreign-key: dimension_name\n /looker/docs/reference/param-explore-join-from: view_name\n /looker/docs/reference/param-explore-join-outer-only: no | yes\n /looker/docs/reference/param-explore-join-relationship: many_to_one | many_to_many | one_to_many | one_to_one \n /looker/docs/reference/param-explore-join-required-joins: [view_name, view_name, ...]\n /looker/docs/reference/param-explore-join-sql-on: SQL ON clause ;;\n /looker/docs/reference/param-explore-join-sql-table-name: table_name ;;\n /looker/docs/reference/param-explore-join-type: left_outer | cross | full_outer | inner \n\n # QUERY PARAMETERS\n /looker/docs/reference/param-explore-join-required-access-grants: [access_grant_name, access_grant_name, ...]\n /looker/docs/reference/param-explore-join-sql-where: SQL WHERE condition ;;\n }\n # Possibly more join declarations\n}\n```\n\nParameter definitions\n---------------------\n\n\u003e | **Note:** The [`always_join`](/looker/docs/reference/param-explore-always-join) parameter specifies any joins that must always be applied to an Explore. That parameter is defined in an [Explore](/looker/docs/reference/param-explore-explore), so it is listed on the [`explore` parameter](/looker/docs/reference/param-explore) page."]]
