Member Avatar for xanawa

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
  • 212 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by mwatson81
Member Avatar for pritaeas

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

Member Avatar for mwatson81

Additional join looks correct to me too.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.