I want to run the following 2 queries in the Query Analyzer :

select campaign from show_title where id = 22436
-- Returns 4698

select campaign_name, id from campaign where id  = 4698

How can I store the result of the first query as a variable and use that
variable in the WHERE clause of the second?