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