> 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
