Exploring many ways to JOIN with multiple conditions

Hello folks, Here I demonstrate different ways to perform a INNER JOIN with multiple clauses. Please consider the following scheme I will use for the examples and pay attention to the Type of Multiplicity (0..1): Product has Zero or one Brand Product has exactly one Category Brand has unlimited number of Products Category has unlimited […]