More about SELECT

This chapter carries on examining the options available with the SELECT command. Most important, you will see how to use joins to use SELECT options with multiple tables. You will also learn how to summarise row details by groups, and carry out more complex subqueries.