Query Joins Settings

Updated October 25, 2021 14:09

Expand-All Collapse-All

Query Joins

Setting	description
Status	Set the status to 'Active' for joins that are being used
Base	The originating base
Base 2	The base to be joined
Name	A descriptive name usually including Base 2 and any other necessary descriptors of configuration options (e.g., Address By Rank Overall)
Type	There are three options. Standard - does not change the row count use LEFT OUTER Multiple - does change the row count use INNER Identity - used to allow a base to inherit exports/filters and joins from another base, rare, will be used to connect a generic base (e.g., Tests) to a specialized base (e.g., ACT Scores).
Memo	Should not be necessary but available if needed to better describe what is happening. Again, everything should be broken down in the such small, simple base units/joins, further description beyond the name should be unnecessary.
Join Clause	Base should be referenced in the join by it's key (e.g., a__JID_) while Base 2 will replace JID with XID (e.g., a__XID_) to allow joins back to the same table and the appropriate alias replacement conditions.
Operands, Operators, Where Prompts	Used to configure a join as before (e.g., filtering address by rank_overall)