The ability to retrieve data from a table is an absolutely essential element of learning SQL. However, real-world requirements often demand the ability to select data from multiple tables concurrently and present it in a meaningful way. Herein lies the ability to join tables. This chapter will cover two distinct syntaxes for joins as well as multiple techniques for combining data from multiple tables.
In this chapter, we shall:
So far, we have seen several ways to select data from tables. ...