Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.

Need to use raw SQL with JPA and JPA? The Jakarta Persistence API's NativeQuery interface makes it possible to use Hibernate, SQL and JPA together in the same app.

SQL history Before there was SQL, databases had tight, navigational programming interfaces, and typically were designed around a network schema called the CODASYL data model.