|
| |
|
|
adamhum
Posts: 28
From: Tucson, Az, USA
Status: offline
 |
Update SQL Help. - 12/27/2001 13:38:48
Would you help me with this SQL stuff? Is it possible to use a table to update another table in SQL Server?
I am attempting to update the columns "campname" and "lastused" in the "listA" table, where the column "eaddress" on the "ListB" table matches the column "column1" on the "ListA" Table.
Is it possible to use another table to update a table?
This is my incorrect syntax:)
"UPDATE ListA, ListB
SET ListA.campname = 'Camp2' AND listA.lastused = '12-30-2001'
WHERE listA.eaddress = ListB.column1"
What do you think?
Adam
|
|
|
|
Spooky
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Update SQL Help. - 12/28/2001 16:18:22
Not really, because column1 isnt defined as a value. The where clause needs a value, just pointing at a column wont do it
§þððk¥
Database / DRW Q & A
VP-ASP Shopping cart
Spooky Login
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
