[thelist] best method for copying records

[David Bindel]

Chris Parker wrote:
> rudy <mailto:rudy937 at rogers.com>
> SELECT
> 	(SELECT LAST_INSERT_ID() FROM savedcart) AS cart_id 	,
prod_id
> 	, price
> 	, qty
> FROM cart_contents

Should be this:

SELECT
	  savedcart.LAST_INSERT_ID() AS cart_id,
	, cart_contents.prod_id
	, cart_contents.price
	, cart_contents.qty
FROM savedcart, cart_contents

HTH,
David Bindel

-- 
    David I. Bindel
  Website Development
 dbindel at austin.rr.com
  www.davidbindel.com