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]

Reply via email to