Multiple Insert Statement?

2004-09-28 Thread Eve Atley
My query: SELECT * FROM wow.resume r INNER JOIN wow.candidate c WHERE r.Section_ID = '1' AND MATCH (r.Section_Value) AGAINST ('+baan' IN BOOLEAN MODE) AND c.Candidate_ID = r.Candidate_ID; Is it possible to do a multiple insert statement like so? INSERT INTO wow.candidate_erp (Candidate_ID

Re: Multiple Insert Statement?

2004-09-28 Thread GH
WHERE r.Section_ID = '1' AND MATCH (r.Section_Value) AGAINST ('+baan' IN BOOLEAN MODE) AND c.Candidate_ID = r.Candidate_ID; Is it possible to do a multiple insert statement like so? INSERT INTO wow.candidate_erp (Candidate_ID, Section_ID, Section_Value) INSERT INTO wow.resume_erp

Re: Multiple Insert Statement?

2004-09-28 Thread Paul DuBois
At 14:16 -0400 9/28/04, Eve Atley wrote: My query: SELECT * FROM wow.resume r INNER JOIN wow.candidate c WHERE r.Section_ID = '1' AND MATCH (r.Section_Value) AGAINST ('+baan' IN BOOLEAN MODE) AND c.Candidate_ID = r.Candidate_ID; Is it possible to do a multiple insert statement like so? No. INSERT

Re: Multiple Insert Statement?

2004-09-28 Thread SGreen
' AND MATCH (r.Section_Value) AGAINST ('+baan' IN BOOLEAN MODE) AND c.Candidate_ID = r.Candidate_ID; Is it possible to do a multiple insert statement like so? INSERT INTO wow.candidate_erp (Candidate_ID, Section_ID, Section_Value) INSERT INTO wow.resume_erp (Candidate_ID, Vendor_ID

RE: Multiple Insert Statement?

2004-09-28 Thread Eve Atley
Then I need help getting on the right track here. What I really want to do is something like the following: INSERT INTO wow.resume_erp (Candidate_ID, Section_ID, Section_Value) SELECT * FROM wow.resume r WHERE r.Candidate_ID = '13103'; INSERT INTO wow.candidate_erp (Candidate_ID, Vendor_ID,

RE: Multiple Insert Statement?

2004-09-28 Thread mos
At 02:56 PM 9/28/2004, you wrote: Then I need help getting on the right track here. What I really want to do is something like the following: INSERT INTO wow.resume_erp (Candidate_ID, Section_ID, Section_Value) SELECT * FROM wow.resume r WHERE r.Candidate_ID = '13103'; You need to match up the

Re: Multiple Insert Statement?

2004-09-28 Thread Rhino
- Original Message - From: Eve Atley [EMAIL PROTECTED] To: Paul DuBois [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, September 28, 2004 3:56 PM Subject: RE: Multiple Insert Statement? Then I need help getting on the right track here. What I really want to do

Re: Multiple Insert Statement?

2004-09-28 Thread Rhino
: Multiple Insert Statement? - Original Message - From: Eve Atley [EMAIL PROTECTED] To: Paul DuBois [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, September 28, 2004 3:56 PM Subject: RE: Multiple Insert Statement? Then I need help getting on the right