Returns a related value from another related table.

Used to join a table and get a value where there is no relationship defined

used in aggregation without related tables

Used to filter data from a standalone table in the data model