October 7th, 2003, 07:38 AM
|
|
Micro Junky
|
|
Join Date: Jul 2002
Location: NJ
Posts: 80
Time spent in forums: 4 h 6 m 43 sec
Reputation Power: 7
|
|
|
Access 2000 SQL Question
I'm having a problem with this code:
UPDATE ipaddress
SET [ipaddress].[computer_name] = [info_add_pc].[info_add]
WHERE (((ipaddress.IP_ID) = (select [info_add_IP].[info_add] from info_add_ip)));
The part that is bolded. When I run it, the message that comes up asks for the parameter to be set.
I guess I'm missing an inner join, or on, but I don't know where t put it.
__________________
The Rog
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
