I can't seem to get the SQL syntax correct in the following problem:
2 Tables SALES and SALESTEMP
Both of them have an ID that provide the link. Both of them have a field
called PurchaseDate.
The original order is inserted into the SALES table but there was an
error on the system date. So I create SALESTEMP with the ID's in question
and fill in the PurchaseDate with a bunch of different dates. All I want
to do is update the PurchaseDate field in SALES with the value in the
SALESTEMP PurchaseDate field. What is the syntax of the SQL statement?
Received on Fri Jun 16 1995 - 00:00:00 CEST
