Join 3 Tables

Hi i am using views in order to join 3 tables

return (from p
                    in this.Entities.priceTypes
                    join userType in this.Entities.userTypes on p.userType equals userType.userTypeID
                  // join product in this.Entities.products on p.product equals product.productID

                    select new CommonDB.Views.PriceTypeView()
                    {
                        ProductName = p.product,
                        Price=p.price,
                    });

I managed to join two tables but i got confused on how to joing the third table (commented one) help please

Contributors

Replies

5 Days

Discussion Span

5 Months Ago

Last Updated

Views

Question
Answered

xanawa

Junior Poster

169 posts since Apr 2010

Reputation Points: 7

Solved Threads: 0

Skill Endorsements: 0

5 Months Ago

The uncommented join looks okay to me. Do you get an error?

pritaeas

Posting Prodigy

Moderator

9,265 posts since Jul 2006

Reputation Points: 1,173

Solved Threads: 1,456

Skill Endorsements: 86

5 Months Ago

Additional join looks correct to me too.

mwatson81

Newbie Poster

7 posts since Sep 2012

Reputation Points: 0

Solved Threads: 2

Skill Endorsements: 0

Question Answered as of 5 Months Ago by pritaeas and mwatson81

This question has already been solved: Start a new discussion instead

You