* Run this code providing your own database connection.
*/
public static void firstRun() throws Exception {
// Create the query
SelectQuery q = create().selectQuery();
q.addFrom(T_AUTHOR);
q.addJoin(T_BOOK, TAuthor.ID.equal(TBook.AUTHOR_ID));
q.addConditions(TAuthor.YEAR_OF_BIRTH.greaterThan(1920));
q.addConditions(TAuthor.FIRST_NAME.equal("Paulo"));
q.addOrderBy(TBook.TITLE);