I keep getting an error,when i am trying to put an insert value within a select, but it won't work! here is a sample of my code:
sql = "INSERT INTO TblOrder (OrderID, BookID, CustomerID, OrderQty, OrderDate, TotalBefDisc) SELECT " + OrderIDBox.Text + "," + BookIDBox.Text + "," + CustBox.Text + "," + QuantityBox.Text + ",'" + DateBox.Text + "', b.UnitPrice * TblOrder.OrderQty from TblBook b WHERE b.BookID = TblOrder.BookID"
sql = "INSERT INTO TblOrder (OrderID, BookID, CustomerID, OrderQty, OrderDate, TotalBefDisc) SELECT " + OrderIDBox.Text + "," + BookIDBox.Text + "," + CustBox.Text + "," + QuantityBox.Text + ",'" + DateBox.Text + "', b.UnitPrice * TblOrder.OrderQty from TblBook b WHERE b.BookID = TblOrder.BookID"