PROBLEM with simple SQL-statement

Hello,

I have some problems with performing a, I think, very simple task in an ORACLE-database (using SQLPLUS).

My plan was to update a column 'amount' with the value of 'price' multiplied by an appropriate VAT-rate from another table. I tried this:

SQL> update MYTABLE set AMOUNT = PRICE *
(select distinct VAT from VATTABLE where CATEG = 2);

It did not work: I got

(select distinct ....

*
missing expression

WHAT must be done differently here???

Thanks for answering.

Jan Willem van der Kooy Received on Wed Jun 15 1994 - 13:08:46 CEST