retrieve data from another related table. I figured around noon that
I really wanted INNER JOIN.
SET ROWCOUNT #url.hs_count#
SELECT *
FROM bodyfun_save_game
INNER JOIN bodyfun_registry
ON bodyfun_save_game.identifier = bodyfun_registry.identifier
ORDER BY high_score DESC
thanks for answering...
>If I undertsood you correctly and if you are using MS SQL [not sure
>about other
>DBMSs], you could awlays do an update from a select: here is an example I used
>recently
--
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]
