|
|
|
|
| Re: Can someone tell me why this update statement is not working....Help [message #371592 is a reply to message #371584] |
Fri, 10 November 2000 03:21  |
John R
Messages: 156
Registered: March 2000
|
Senior Member |
|
|
What it might be is this:
You seem to be setting the value of A.Data_From_Tble to a value held in another table.
If this is the case, yo are missing a SELECT statement.
Try this:
update REGISTRATION_HIST A
set A.DATA_FROM_TBLE = (SELECT required_value
from MEETING_REGISTRANT B, MEETING C
WHERE A.CUSTOMER = B.SHIP_CUSTOMER
AND A.MTG_CODE = B.MEETING
AND B.MEETING = C.MEETING
AND A.BEGIN_DATE = C.BEGIN_DATE
AND A.END_DATE = C.END_DATE)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
