UPDATE a column using the value in another table 1

[deucesp97]

I am trying to use the UPDATE statement to update a table that currently has data. There is a column "QUEUE_DT" that I need to update using the data currently in the table. I would like to do something like this:

UPDATE INVOICE
SET QUEUE_DT = SCE5200.APROVQUECREATEDT
FROM SCE5200 LEFT JOIN INVOICE
ON SCE5200.DOCID = INVOICE.INVOICE_NUMBER
WHERE INVOICE.REV_TYPE = 'APR';

Any suggestions! [sig][/sig]

 

[listener22]

UPDATE INVOICE
SET QUEUE_DT =
(select SCE5200.APROVQUECREATEDT
FROM SCE5200
where SCE5200.DOCID = INVOICE.INVOICE_NUMBER)
WHERE INVOICE.REV_TYPE = 'APR'; [sig]<p>Jim<br><a href= > </a><br>oracle, vb, some javascript[/sig]