Multiple InnerJoin

Question

I would like for a multiple table to be Inner joined but somehow, the FROM is not reading. The columns aren't filled with the datas. But they're generating the columns. Is FROM Statement wrong?

SELECT Customer.CID, Customer.FName, Customer.LName, Customer.Address, Customer.ContactNo,
   Book.BID as Book_SerialNo, Book.Title, ShoppingCart.Quantity, Order1.Status, Order1.ODate

FROM Customer Inner Join ShoppingCart on Customer.CID = ShoppingCart.CID, 
 Order_Book_Junction Inner Join Book on Order_Book_Junction.BID = Book.BID
 Inner Join Order1 on Order_Book_Junction.OID = Order1.OID

Just putting this out there, this isn't a C# issue, looks like a SQL issue to me — Toxicable, May 29 '16 at 07:48

score 0 · Accepted Answer · answered May 29 '16 at 07:54

0

it's sql question not C#

You should run it in sql and see the error message or maybe not an error query doesn't return any row ,Change From statement to (maybe help) :

   FROM Customer 
   Inner Join ShoppingCart
          on Customer.CID = ShoppingCart.CID 
   Inner Join Book
          on Order_Book_Junction.BID = Book.BID
   Inner Join Order1
          on Order_Book_Junction.OID = Order1.OID

answered May 29 '16 at 07:54

Arman.Salehi

96
5

This is the error message i get when i test in sql `The multi-part identifier "Order_Book_Junction.OID" could not be bound.` – Minial May 29 '16 at 08:02
So its your main question, and look at here : http://stackoverflow.com/questions/7314134/the-multi-part-identifier-could-not-be-bound – Arman.Salehi May 29 '16 at 08:14

Multiple InnerJoin

1 Answers1