Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
davidshq
Posting Yak Master
119 Posts |
 Posted - 2005-06-28 : 12:22:16
|
| I have two tables. The one is named Game, the other LastPlayed. Each Game has a unique ID. In LastPlayed there is a field that contains this unique ID entitled, "gID". In the Game table there is a "LastPlayed" field, which is always empty. In the LastPlayed table there is a "LastPlayedDate" field which is sometimes empty, sometimes full. I want to perform a join that matches the Game.ID with the LastPlayed.gID and then changes the Game.LastPlayed null field to be equal to the Game.LastPlayedDate field. Any ideas?David.- http://www.civilwarsearch.com/- http://www.thehungersite.com/- http://www.grid.org/ |
|
|
davidshq
Posting Yak Master
119 Posts |
|
|
|
|
|
Joining Tables.