DBMSs], you could awlays do an update from a select: here is an example I used
recently
UPDATE someUsersTable
SET someUsersTable.EmailPrivate = someOtherJoinTable.PublicEmail
FROM someUsersTable INNER JOIN someOtherJoinTable ON someUsersTable.userID =
someOtherJoinTable.userID
WHERE (tbl_Users.userEmailPrivate = '')
So start off by writing your select statement and then replace the select
column_names with your update statement.
Cheers
G
=====================================
e: [gregs]at[teacupinastorm].[com]
w: http://www.teacupinastorm.com/
b: http://gregs.teacupinastorm.com/
=====================================
Quoting Daniel Kessler <[EMAIL PROTECTED]>:
> I have a login and a save_game database.
> loginDB: | id | name | pw |
> save_gameDB: | id foreign key to loginDB id | score | game info |
>
> I'm querying the save_game database for a list of the top 20, but
> right now I'm getting the save_game id. I want to replace that with
> the loginDB name info from the related record. Is there a way to do
> that within the same query or do I have to do 20 more queries once I
> get the original list, so that I can get the name for each? That
> sounds wasteful, so I'm hoping there's another way.
>
> thanks and good morning.
>
> --
> Daniel Kessler
>
> Department of Public and Community Health
> University of Maryland
> Suite 2387 Valley Drive
> College Park, MD 20742-2611
> 301-405-2545 Phone
> www.phi.umd.edu
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
