>
> UPDATE SHDayD
> SET Department = Product.Department
> FROM SHDayD, Product
> WHERE SHDayD.ScanCode = Product.ScanCode
>
> (I think Davids version was wrong)
>
... not wrong, just not as correct as your version!
I believe my version was the old SQL 6.5 Update syntax and I wondered after
I posted it whether I should have included the new syntax for completeness.
As it turns out probably neither works because it's a paradox query!
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/
