Lovefield is a JavaScript library providing an SQL-like query engine to web developers who want the benefits of a relational database.

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