title: SQL: Two select statements in one query
body: <p>I want to select information from two SQL tables within one query, the information is unrelated though, so no potential joints exist.</p>
  
  <p>An example could be the following setup.</p>
  
  <p>tblMadrid</p>
  
  <pre><code>   id | name    | games | goals
      1 | ronaldo | 100   | 100
      2 | benzema | 50    | 25
      3 | bale    | 75    | 50
      4 | kroos   | 80    | 10
  </code></pre>
  
  <p>tblBarcelona</p>
  
  <pre><code>   id | name    | games | goals
      1 | neymar  | 60    | 25
      2 | messi   | 150   | 200
      3 | suarez  | 80    | 80
      4 | iniesta | 40    | 5
  </code></pre>
  
  <p>I want to have a query that gives me the following:</p>
  
  <pre><code>name    | games | goals
  messi   | 150   | 200
  ronaldo | 100   | 100
  </code></pre>
  
  <p>I tried to follow this logic: <a href="https://stackoverflow.com/questions/1775168/multiple-select-statements-in-single-query">Multiple select statements in Single query</a> but the following code did not work:</p>
  
  <pre><code>USE Liga_BBVA
  
  SELECT (SELECT name,
                 games,
                 goals
          FROM   tblMadrid
          WHERE  name = 'ronaldo') AS table_a,
         (SELECT name,
                 games,
                 goals
          FROM   tblBarcelona
          WHERE  name = 'messi')   AS table_b
  ORDER  BY goals 
  </code></pre>
  
  <p>Any advice on this one? Thanks
  Info: The football stuff is just a simplifying example. In reality it is not possible to put both tables into one and have a new "team" column. The two tables have completely different structures, but I need something that matches the characteristics of this example.</p>