SELECT * FROM bodyfun_save_game, MAX(20)
ORDER BY high_score DESC
At 9:00 AM -0500 3/17/04, Daniel Kessler wrote:
>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.
--
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]
