I'm currently working on a database that includes a table to keep track of customers. This table holds (among other things) the customer's address. To date, these addresses have all been located ...

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 ...