The subjunctive mood can be a rather difficult concept. Very generally speaking, it is used in relative clauses that express formal commands, requests, or desires:
"It is imperative that you
be there tomorrow."
(Formal command)
"I ask that you
be on time tomorrow."
(Request)
These sentences are in the simple present subjunctive, but the subjunctive mood can be used for any of the other standard (indicative) verb tenses.
You can find a basic overview of the subjunctive
here; it explains things much more thoroughly than I can.