man, you guys are ON IT! thanks. the following
worked like a charm:
UPDATE t_job_number
SET contract_id = 30
WHERE job_number_id = (select job_number_id from
t_serial_number where serial_number_id = 78);
i have to spend some time figuring out exactly where i
fumbled the ball the first time around...
thanks, everyone.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com