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.
the act of competing; rivalry for supremacy, a prize, etc.: The competition between the two teams was bitter. 2. a contest for some prize, honor, or advantage: Both girls entered the competition.