Need Immediate Help on UPDATE SQL

deepakatfre · #1 (**permalink**) 08-28-04, 23:09

Hi
This is on UDB 8.01.005

I want to know how could I convert this sybase query into UDB

UPDATE TABLE A
SET B.price = A.PRICE
FROM
TABLE A, TABLE B
Where
A.no = B.no And
A.dt = B.dt

Marcus_A · #2 (**permalink**) 08-28-04, 23:18

Try this (but I have not tested it):

UPDATE TABLE A
SET A.Price =
( SELECT B.Price
FROM TABLE B
WHERE A.no = B.no
AND A.dt = B.dt )

Internet Services

Web Development

Digital Marketing

Consumer Tech