Using Two Relations in a Query

Till now, every query in this chapter has worked with data from a single relation at a time. This section introduces writing queries that use two relations together — the foundation for combining related data stored in separate tables, which is covered starting wi …