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