Re: Copying data from one table to another.

2001-09-10 Thread Eric Spletzer
Will this actually work? Because I can't select from the table into which I'm inserting. Also I don't want to insert. I want to update a bunch of records that already exist. Here is exactly what I want to do. I have two tables set up that I'm dealing with right now.  One is the main informati

Re: Copying data from one table to another.

2001-09-10 Thread Sheridan Saint-Michel
I think what you are looking for is the Insert...Select statement http://www.mysql.com/doc/I/N/INSERT_SELECT.html Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: "Eric Spletzer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent