Microsoft® Visual C#® .NET 2003 Kick Start

Working with Relational Databases

Relational databases are powerful databases that connect the data in multiple tables. For example, say that you are using the pubs sample database that we've already used in this chapter, and want to display all the books that the authors in the authors table have written. That's not a simple task, because in the pubs database, the names of the authors are stored in the authors table, but the books that they've written are stored in the titleauthor table (these books are actually stored by book ID, not by title). And the titleauthor table is a separate table.

How do you join the authors names from the authors table with the titles they've written from the titleauthor table into one dataset? You can use a SQL ...