Stephan,
You can not join within an update clause - 'update' supports one table
only.
regards,
P
On Wed, 25 Apr 2001, Stéphane PRIN wrote:
> > database,sql,query
>
> > Hi everybody,
> >
> > i have 2 tables
> >
> > 1) test
> > - id_test
> > - country_name
> > - etc...
> >
> > 2) country
> > - id_country
> > - contry_name
> >
> >
> > i want to join this 2 tables in case of deuce of the country_name
> > and update test.id_test with the value of country.id_country
> >
> > i try tis syntax: "update test,country set id = country.id_country where
> > test.country_name = country.country_name"
> > but it doesn't works ...
> >
> >
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
--
-----------------------------------------------
Peter Skipworth
Perl Developer/Unix Systems Administrator
[EMAIL PROTECTED]
+44 795 055 0029
-----------------------------------------------
4c 61 20 6c 6f 79 52 75 62 20 73 41 20 65 52 61
20 45 65 62 4f 4c 47 6e 74 20 20 4f 53 75 00 0a
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php