Thank you very much for your help

Ben

Thanks for the reply.

Here is what I have got working so far
CREATE PROCEDURE [pr_Prize_Winner]
AS
SELECT TOP 1
u.[User_ID], u.[first_name], u.[last_name]
FROM [User] u, [Issue]...