Transferring data from two tables into another two tables at the same time. [Answered]RSS

• • Reply
  

  sasalyn

  None

  0 Points

  6 Posts

  Transferring data from two tables into another two tables at the same time.

  Nov 04, 2012 01:35 AM|sasalyn|LINK

  I faced problems in transferring data from two tables into another two tables at the same time..

  I used LEFT OUTER JOIN to join both tables but there's still have errors..

  string UpdateOrder = "INSERT INTO Order LEFT OUTER JOIN OrderDetails ON Order.orderNo = OrderDetails.orderNo (Order.orderDate,Order.totalOrderPrice,Order.membershipNo, OrderDetails.productNo, OrderDetails.productQty, OrderDetails.subTotalOrderPrice, OrderDetails.productColor,OrderDetails.productRemarks)" +
  "SELECT ShoppingCart.cartDate,ShoppingCart.totalCartPrice,ShoppingCart.membershipNo, CartDetails.productNo, CartDetails.productQty, CartDetails.subTotalOrderPrice, CartDetails.productColor,CartDetails.productRemarks" +
  "FROM ShoppingCart LEFT OUTER JOIN CartDetails ON ShoppingCart.cartNo = CartDetails.cartNo";

  any one can help on this ???

• • Reply
  

  oned_gk

  All-Star

  50490 Points

  14820 Posts

  Re: Transferring data from two tables into another two tables at the same time.

  Nov 04, 2012 06:20 AM|oned_gk|LINK

  can insert into joining table?
  Programming to simplify, don't look for hardway ...
  Suwandi - Non Graduate Programmer
• • Reply
  

  sasalyn

  None

  0 Points

  6 Posts

  Re: Transferring data from two tables into another two tables at the same time.

  Nov 04, 2012 12:14 PM|sasalyn|LINK

  I want to retrieve data from two tables into another two tables.

• • Reply
  

  hans_v

  All-Star

  25756 Points

  7025 Posts

  Re: Transferring data from two tables into another two tables at the same time.

  Nov 04, 2012 05:12 PM|hans_v|LINK

  sasalyn

  I faced problems in transferring data from two tables into another two tables at the same time..

  Because you cannot insert data into 2 tables in 1 INSERT statement at the same time. You need to execute 2 INSERT statements

• • Reply
  

  Decker Dong...

  All-Star

  94110 Points

  18123 Posts

  Re: Transferring data from two tables into another two tables at the same time.

  Nov 04, 2012 08:54 PM|Decker Dong - MSFT|LINK

  sasalyn

  I used LEFT OUTER JOIN to join both tables but there's still have errors..

  What problem have you got?

  Can you elebrate it more?

  Exception?