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

3
Contributors
2
Replies
3
Views
4 Years
Discussion Span
Last Post by mwatson81
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.