title: Setup and Query a database for Head-to-Head records
body: <p>I am trying to learn mysql while creating something fun for my fantasy football league.  I am creating a table that will hold each game we have ever played and want to be able to query the table to show the head-to-head record for any given owners.  So for example Team A vs Team B or Team A vs Team D.</p>
  
  <p>Here is what I was thinking for my table:</p>
  
  <p><a href="http://i.stack.imgur.com/JdGpU.jpg" rel="nofollow">Table</a></p>
  
  <p>1st - If there is a better way to setup the table I am all ears.</p>
  
  <p>2nd - I haven't been able to find away to pull this information, at least not that has made sense or worked for me.  Can anyone help get me started?</p>
  
  <p>Thanks</p>