how to implement join in linq to sql query
Here are some samples based on your problem:
LINQ To SQL Samples