When you execute a statement like this, SQL creates a new table—the results recordset—based on the contents of table1 and table2. You specify which fields from the two tables you want to see ...

You often need data that are stored in separate tables. For example, you may want to produce a report that gets information about flight delays from one table and boarding capacity from another.

The SQLite3 command line interface makes it incredibly easy to create databases, configure tables, delete records and even get status updates on the state of your SQLite database.

The MySQL Workbench GUI is cross-platform, open source, and incredibly easy to use.

A developer shouldn't spend time on database table creation when unit tests run. Instead, have Hibernate create tables in the database for JPA and other data-driven applications.