View Single Post
  #2 (permalink)  
Old September 13th, 2010, 02:57 AM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Hi there,

Take a look at page 414 in Chapter 12, section Joining Data.

The following example show something similar, where the Name (not just the ID) of a Genre is queried with a Review:

Code:
 
SELECT
  Review.Id, Review.Title, Genre.Name
FROM
  Review
Code:
INNER JOIN Genre ON Review.GenreId = Genre.Id


Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
The Following User Says Thank You to Imar For This Useful Post:
bertus (September 22nd, 2010)