Loading ...
Sorry, an error occurred while loading the content.

2226Different teamID's for A.A. Baltimore teams

Expand Messages
  • wknight94
    Oct 1, 2004
    • 0 Attachment
      Why do the 1890 and 1891 A.A. Baltimore Orioles have a different
      teamID (BL3) than the A.A. Baltimore Orioles from 1882 to 1889 (BL2)?


      select name, teamid, lgid, yearid from teams where franchid = "BLO"

      +-------------------+--------+------+--------+
      | name | teamid | lgid | yearid |
      +-------------------+--------+------+--------+
      | Baltimore Orioles | BL2 | AA | 1882 |
      | Baltimore Orioles | BL2 | AA | 1883 |
      | Baltimore Orioles | BL2 | AA | 1884 |
      | Baltimore Orioles | BL2 | AA | 1885 |
      | Baltimore Orioles | BL2 | AA | 1886 |
      | Baltimore Orioles | BL2 | AA | 1887 |
      | Baltimore Orioles | BL2 | AA | 1888 |
      | Baltimore Orioles | BL2 | AA | 1889 |
      | Baltimore Orioles | BL3 | AA | 1890 |
      | Baltimore Orioles | BL3 | AA | 1891 |
      +-------------------+--------+------+--------+

      Thanks.

      Bill Knight
    • Show all 5 messages in this topic