The FROM Clause

The SQL FROM clause allows for specifying which table to select data from. This also tells SqliteMagic what type of objects to parse and produce.

SQL	SqliteMagic
SELECT * FROM AUTHOR SELECT * FROM AUTHOR AS 'a' </code></pre> </td> <td style="padding:0; margin:0; border:none; width:50%;"> <pre lang="java"><code class="language-java">import static com.siimkinks.sqlitemagic.AuthorTable.AUTHOR; Select.from(AUTHOR); Select.from(AUTHOR.as("a")) </code></pre> </td>

See Next

• TheSELECT Clause
• The JOIN Clause
• The WHERE Clause
• The GROUP BY Clause
• The HAVING Clause
• The ORDER BY Clause
• The LIMIT .. OFFSET Clause
• Generated Tables
• Aliased Tables
• Nested Selects
• Column Expressions
• Conditional Expressions