1,105,636 Community Members

Join 3 Tables

Member Avatar
xanawa
Junior Poster
171 posts since Apr 2010
Reputation Points: -3 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

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

Member Avatar
pritaeas
mod_pritaeas
11,332 posts since Jul 2006
Reputation Points: 1,420 [?]
Q&As Helped to Solve: 1,835 [?]
Skill Endorsements: 156 [?]
Moderator
Featured
Sponsor
 
0
 

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

Member Avatar
mwatson81
Newbie Poster
7 posts since Sep 2012
Reputation Points: 0 [?]
Q&As Helped to Solve: 2 [?]
Skill Endorsements: 0 [?]
 
0
 

Additional join looks correct to me too.

Question Answered as of 1 Year Ago by pritaeas and mwatson81
You
This question has already been solved: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article