APIs seem to be everywhere these days. Every popular online service has one. APIs allow developers to interact with online services without actually having to point and click their way through a UI.

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...