[[["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-08-20 UTC."],[],[],null,["# LookmlModelExploreJoins\n\nVersion 4.0.25.14 (latest) \nDatatype \nDescription \n(object) \nobject \nname \n*lock* \nstring \nName of this join (and name of the view to join) \ndependent_fields \nstring\\[\\] \nfields \nstring\\[\\] \nforeign_key \n*lock* \nstring \nName of the dimension in this explore whose value is in the primary key of the joined view \nfrom \n*lock* \nstring \nName of view to join \nouter_only \n*lock* \nboolean \nSpecifies whether all queries must use an outer join \nrelationship \n*lock* \nstring \nmany_to_one, one_to_one, one_to_many, many_to_many \nrequired_joins \nstring\\[\\] \nsql_foreign_key \n*lock* \nstring \nSQL expression that produces a foreign key \nsql_on \n*lock* \nstring \nSQL ON expression describing the join condition \nsql_table_name \n*lock* \nstring \nSQL table name to join \ntype \n*lock* \nstring \nThe join type: left_outer, full_outer, inner, or cross \nview_label \n*lock* \nstring \nLabel to display in UI selectors\n\nRelated Types\n-------------\n\n- [LookmlModelExplore](./LookmlModelExplore \"LookmlModelExplore\")"]]
