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

To SQL or NoSQL? That’s the database question But as technological lines blur, there's not always a clear-cut answer.