title: SELECT from VIEW with FMDB
body: <p>I have an SQLite database with the following tables:</p>
  
  <ul>
  <li>Player</li>
  <li>Card</li>
  <li>Team</li>
  <li>PlayerCard</li>
  </ul>
  
  <p>CardDataComposed is a VIEW created with the following SELECT:</p>
  
  <pre><code>SELECT Player.PlayerID, Player.PlayerFirstName, Player.PlayerLastName, Card.CardID, Team.TeamID, Team.TeamName
  
  FROM Player, Card, PlayerCard, Team 
  WHERE Player.PlayerID=PlayerCard.PlayerID
  AND Card.CardID=PlayerCard.CardID 
  AND Team.TeamID=PlayerCard.TeamID;
  </code></pre>
  
  <p>Using the sqlite3 command line tool, <code>SELECT * FROM CardDataComposed</code> returns all of the records. However using the same query with FMDB:</p>
  
  <pre><code>NSString *dbQuery = @"SELECT * FROM CardDataComposed";
  [self.database executeQuery:dbQuery];
  </code></pre>
  
  <p>Does not return any records. I imagine it has to do with how I'm (incorrectly) putting together the query so that FMDB can retrieve the records properly. How do I fix my query to select records from this view? Am I able to query views from FMDB? Thanks in advance!</p>