Outer joins can be left outer joins or can be right outer joins. In a left outer join, the query includes all of the rows from the first table in the SQL statement FROM clause, and only those rows from the other table where the joining field contains values common to both tables.
Rival \Rival\, v. t. [imp. & p. p. Rivaledor Rivalled; p. pr. & vb. n. Rivaling or Rivalling.] 1. To stand in competition with; to strive to gain some object in opposition to; as, to rival one in love. [1913 Webster] 2. To strive to equal or exel; to emulate.
Competition is, in general, a contest or rivalry between two or more entities, organisms, animals, individuals, economic groups or social groups, etc., for territory, a niche, for scarce resources, goods, for mates, for prestige, recognition, for awards, for group or social status, or for leadership and profit. It arises whenever at least two parties strive for a goal which cannot be shared, where one's gain is the other's loss. Competition occurs naturally between living organisms which co-exis