updating one table with info from another

How is this done?

Cause update comments set subscriber='Y' where comments.supplier =
company.company_name doesn't work

Yet, select comments.subscriber, comments.supplier, company.company_name
where comments.supplier = company.company_name does work....

--

Kind Regards
Rudi Ahlers
+27 (82) 926 1689

For as he thinks in his heart, so he is. ... (Proverbs 23:7)

"Rudi Ahlers" <Rudi@Bonzai.org.za> wrote in message
news:SuCdnc3OPas7ocLdRVn-uw@is.co.za...
> How is this done?
>
> Cause update comments set subscriber='Y' where comments.supplier =
> company.company_name doesn't work
>
> Yet, select comments.subscriber, comments.supplier, company.company_name
> where comments.supplier = company.company_name does work....
>
> --
>
> Kind Regards
> Rudi Ahlers
> +27 (82) 926 1689
>
> For as he thinks in his heart, so he is. ... (Proverbs 23:7)
>
>

where is your "from" statement ? This doesnt look correct.

I would expect something like...

update comments set subscriber='Y' from comments, company where
comments.supplier =
company.company_name