SQLite Select Statement - Where two conditions are met? <p>Can someone please correct my select statement, the below works selecting everything from table 'games' where 'genre=fps'.</p> <pre><code>tx.executeSql('SELECT * FROM games WHERE genre=fps', [], renderResults); </code></pre> <p>I don't know how to, or if it is possible to expand upon this to to select everything where 'genre=fps' and 'decade=90' - something like this:</p> <pre><code>tx.executeSql('SELECT * FROM games WHERE genre=fps AND decade=90', [], renderResults); </code></pre> <p>or</p> <pre><code>tx.executeSql('SELECT * FROM games WHERE genre=fps AND WHERE decade=90', [], renderResults); </code></pre> <p>Is the above possible? This is probably really straightforward but I cant find any examples or tutorials to follow.</p> <p>Any help would be great.</p> <p>Thanks</p>