select campaign_name, id from campaign where id  = 
  (select campaign from show_title where id = 22436)

>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?