Its smart inner join. If we have 2 tables connected via ref. join and a query is written on Attr. View and do not include the join column or the column on master check table. Essentially you are just selecting data from main table, The join will be “pruned” (exclude – don’t care. When you also apply an filter on data model, the ref. join also acts like inner join Text Join This join type is used to obtain language-specific data from the text tables using a language column. Full Outer Joins This join type displays results from both left and right outer joins and returns all (matched or unmatched) rows from the tables on both sides of the join clause. Text Join A join between master table and its text table with language key Temporal Join join for timeframe – also known as Equi-join. BETWEEN condition in select query. ** applicable only on Analytical Views Star join Its only used in calculation views, it is used to combine multiple fact table directly. Spatial Join used to join coordinates table
