What is the syntax for an update query if I want to reference another table ?
I.E UPDATE SHDayD SET Department = Product.Department WHERE (ScanCode = Product.ScanCode) But it doesny work. --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe delphi" Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/