“Small cheer and a great welcome makes a merry feast.”
—WILLIAM SHAKESPEARE COMEDY OF ERRORS, ACT 3, SCENE 1
By now, you know how to create a set of information by asking for specific columns or expressions on columns (SELECT), how to sort the rows (ORDER BY), and how to restrict the rows returned (WHERE). Up to this point, I’ve been focusing on basic exercises involving a single table. But what if you want to know something about information contained in multiple tables? What if you want to compare or contrast sets of information from the same or different tables?
Creating a meal by peeling, slicing, ...