> 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)
>
Depends a bit on which version of SQL you are using but the following would
work on SQL Server:
UPDATE SHDayD
SET Department = Product.Department
FROM Product
WHERE (SHDayD.ScanCode = Product.ScanCode)
David.
---------------------------------------------------------------------------
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/
