Groups > comp.databases.ms-sqlserver > #1732

How could I add ProductName in this select query

Path	csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!feeder.erje.net!eu.feeder.erje.net!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From	"Tony Johansson" <johansson.andersson@telia.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	How could I add ProductName in this select query
Date	Sat, 15 Mar 2014 17:05:52 +0100
Organization	A noiseless patient Spider
Lines	27
Message-ID	<lg1tp6$ldu$1@dont-email.me> (permalink)
Mime-Version	1.0
Content-Type	text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding	7bit
Injection-Date	Sat, 15 Mar 2014 16:05:58 +0000 (UTC)
Injection-Info	mx05.eternal-september.org; posting-host="8fdc2b5af81c338deb7045fc6c39b0e2"; logging-data="21950"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/cKycmLOf+JlnAONOUBvM1"
X-MimeOLE	Produced By Microsoft MimeOLE V6.0.6002.18463
X-Newsreader	Microsoft Windows Mail 6.0.6002.18197
Cancel-Lock	sha1:g2ZgQJbVkkzEusogDKqX8qbaO/M=
X-Priority	3
X-MSMail-Priority	Normal
Xref	csiph.com comp.databases.ms-sqlserver:1732

Show key headers only | View raw

I have this relation. The BookingDetails is a connection table because we 
have many to many between Booking and Products table
One Customers can have many bookings
Booking  (1)----------(m)BookingDetails 
(m)-----------------------(1)Products
   (m)
    |
    |
    |
  (1) Customers

The primary key in Products is ProductID
In this select clause I want to add in the result the ProductName that exist 
in the Product table.
How could I do that ?

Command.CommandText = "SELECT BokningFromDate, BokningToDate, Name, Address, 
Phone, ProductID, EnhetsPris " +
          "FROM Bokningar " +
          "INNER JOIN Customers " +
          "ON Bokningar.CustomerID = Customers.CustomerID " +
          "INNER JOIN BokningDetails " +
          "ON Bokningar.BokningarID = BokningDetails.BokningarID " +
          "ORDER BY Name asc";

//Tony

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

How could I add ProductName in this select query "Tony Johansson" <johansson.andersson@telia.com> - 2014-03-15 17:05 +0100
  Re: How could I add ProductName in this select query Erland Sommarskog <esquel@sommarskog.se> - 2014-03-15 17:30 +0100
    Re: How could I add ProductName in this select query "Tony Johansson" <johansson.andersson@telia.com> - 2014-03-15 17:50 +0100
      Re: How could I add ProductName in this select query "Tony Johansson" <johansson.andersson@telia.com> - 2014-03-15 18:09 +0100

csiph-web