1.11M Members

Join 3 Tables

 
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

 
0
 

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

 
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