Update Query

[Ben Levitt]

I have the following query in Oracle that I would like to port over to MS
Access:

UPDATE Table1 "A"
SET A.description = (
SELECT B.description
FROM Table2 "B"
WHERE A.ID = B.ID)

Does anyone know how to create this query in Access. I get an Error 'Must
use Updateable Query' when I type this into the SQL design view.

Thanks in Advance-
Ben
benjami...@jamminsoftware.com

[Max Dunn]

UPDATE Table1 INNER JOIN Table2 ON Table1.ID = Table2.ID SET
Table1.Description = [Table2].[Description];

Or do you have a need to alias the table?

Max
http://www.siliconpublishing.org/

"Ben Levitt" <benjami...@hotmail.com> wrote in message
news:uVAKqNasAHA.684@tkmsftngp03...