Yes, that did the trick. Thanks.

--- Igor Tandetnik <[EMAIL PROTECTED]> wrote:
>  UPDATE accomodation
>  SET country = (
>   SELECT c.country
>   FROM country c
>   WHERE c.country_id = accomodation.country_id
>  );
> 
> Igor Tandetnik
> 
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

Reply via email to