Jun 23rd, 2005, 15:54
|
|
New Member
|
|
Join Date: Jun 2005
Location: USA
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Quote:
|
Originally Posted by D3mon
Sorry, it looks Like it was INSERT INTO instead of SELECT INTO. Here's the query I use, perhaps you can modify it for your own purposes:
- Code: Select all
INSERT INTO tblOrderItem
SELECT @orderID as 'orderid',
P.productid,
multiple as 'quantity',
P.Price as 'price'
FROM tblBasketItems
INNER JOIN tblProducts P
ON P.ProductID = tblBasketItems.ProductID
WHERE tblBasketItems.basketID = @basketID
|
But I believe that will Insert new records instead of updating the older ones |