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 ...

Get Microsoft® Visual C#® .NET 2003 Kick Start now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.