RE: Copying rows based on query result to another table?

2004-09-15 Thread Eve Atley
(r.Section_Value) AGAINST ('+BAAN' IN BOOLEAN MODE) AND c.Candidate_ID = r.Candidate_ID -Original Message- From: Peter Lovatt [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 1:29 PM To: [EMAIL PROTECTED]; Mysql Subject: RE: Copying rows based on query result to another table

Copying rows based on query result to another table?

2004-09-14 Thread Eve Atley
I want to copy rows of data from a query result to another table. How do I accomplish this? Here's my example for further explanation... I have 2 tables, candidate and resume. I have 2 other (currently empty) tables, exact duplicates, candidate_erp and resume_erp. In resume_erp will be

RE: Copying rows based on query result to another table?

2004-09-14 Thread Peter Lovatt
Atley [mailto:[EMAIL PROTECTED] Sent: 14 September 2004 18:18 To: Mysql Subject: Copying rows based on query result to another table? I want to copy rows of data from a query result to another table. How do I accomplish this? Here's my example for further explanation... I have 2 tables