Another option c/ Joined update
UPDATE SHDayD, Department SET SHDayDDepartment = Product.Department WHERE SHDayD.ScanCode = Product.ScanCode Neven ----- Original Message ----- From: "James Sugrue" <[EMAIL PROTECTED]> To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]> Sent: Tuesday, October 02, 2001 10:20 AM Subject: [DUG]: Update SQL Syntax > 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/ > --------------------------------------------------------------------------- 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/
