I know that this is off topic and such... but can you explain the
Match / Against that you used in your query? i have never seen syntax
like that in SQL
On Tue, 28 Sep 2004 14:16:56 -0400, Eve Atley <[EMAIL PROTECTED]> 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?
>
> INSERT INTO wow.candidate_erp
> (Candidate_ID, Section_ID, Section_Value)
> INSERT INTO wow.resume_erp
> (Candidate_ID, Vendor_ID, etc.)
> SELECT SQL_CALC_FOUND_ROWS *
> FROM wow.resume r
> INNER JOIN wow.candidate c;
>
> Or do I have to break out the INSERT statements seperately?
>
> Thanks!
> - Eve
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
