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

Question

User1814848029 posted

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 ???

Answer 1

User-1716253493 posted
can insert into joining table?

Answer 2

User1814848029 posted

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

Answer 3

User-1199946673 posted

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

Answer 4

User3866881 posted

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?