combining two tables

[yoonie_85]

hello there,

I have written a query in access '97 that compares two ID numbers from two separate tables...and if they are equal, i want to copy and paste the phone number, etc into the "originial" from "res_phone"

but I keep getting an error that says :
"Syntax error (missing operator) in query expression 'T2.Extention
FROM Original As T1'."

I dont know where i'm going wrong. I was wondering if anyone could help me out. Thanks so much.

here's my code:

UPDATE Original
SET PhoneNumber = T2.PhoneNumber,
  AreaCode = T2.AreaCode,
  Extention = T2.Extention
FROM Original As T1, Res_Phone As T2
WHERE T1.CustCode = T2.CustCode AND T1.PremCode = T2.PremCode

 

[MStef]

Hello yoonie!
Look at "DemoUPDPhoneNumA97.mdb"
Look at tblOriginal (ID 2 and 5)
Look at tblResPhone
Start Query1
(MStef alias Štef)