Statement in its current state:

Code:
select Number,
   (Select ComicTitle
       from standalones
       join comicnames on standalones.SoloID = comicnames.SoloID
       join comics on comics.comicID = comicnames.comicID
       where Number = [Comic_Number]
   ) AS "ComicName" from comics;
What I need to do is set the variable so that [Comic_Number] will equal Number in this statement.