All right, the English subjunctive mood is tricky mostly because, in modern English, it's considered in many areas to be moribund or outmoded. In most situations, the indicative and subjunctive can live side by side and have, in fact, done so since Middle English times. I went to school for English and many of my theses have been written on this topic. I shall break down the subjunctive, which can have a very formal, sometimes archaic feel to it, but is still quite beautiful, to say the least. Here are some examples in the subjunctive mood (some examples may have a modal that replaces the subjunctive forms):
Assuming that he be correct, can we still get to the show in time?
"And ne'er throughout the year to church thou go'st/Except it be to pray against thy foes" (Shakespeare).
I pray that God give them the serenity that they may forgive this man.
O that I were the President of the United States. What policies I would invoke were I holding that office.
I can only hope that he find true love one day. It's my only hope and wish that he be as lucky as I have been in my lifetime with my wife.
Should he violate the terms of his parole, he shall be returned to prison forthwith.
Whether the committee sanction him or not, he will still remain in his tenured position on the board.
It is important that the students do their own work.
I demanded that they not say another word.
Though he face many perils, he will ultimately succeed. (Also, though he may face many perils...).
It's better if he go with you.
If you had gone to school, you would have had to take a test.
I wish I were an Oscar Meyer wiener.
If only he knew the answer, he wouldn't be in this predicament.
It is the judgment of this court that you be sentenced to probation.
He will be permitted to attend the ceremony provided he dress accordingly.
We shall do it on the condition that we be paid $5,000.
In the event that he died right now, his estate would devise to his next of kin.
As long as he have answered all of the questions, the chances of his failing are slim.
They will plant trees along the street in memory of the victims so that no one ever forget them.
If he go to the store, he will buy some eggs.
If I were to go with you, I would never forgive myself.
He fled the country lest he be captured and imprisoned.
The above examples are all correct under the rules of English grammar; however, many of them would be considered archaic if they were used today. Despite their being overly formal or archaic, they limn the usage of the subjunctive in English in a diachronic analysis more so than just capturing its modern usage. None of the 23 examples above could be deemed ungrammatical, but many people might categorize them as stilted nonetheless. These examples were not shown to be stilted; they were shown so that readers could see the entire usage of the subjunctive.
The subjunctive can be used after many other coordinating conjunctions like "until", "unless", "although", and "before". It can also be used after subordinating "that" clauses when those clauses are linked by words of necessity, possibility, contingency, commands, requests, aspirations, supplications, doubts, fears, and other operative words that evoke latent emotions that do not necessarily indicate that an event happens, will happen, or has happened. Those words that would indicate such actual events would fall into the indicative mood, which is the common mood of language: "He is the one. I went to the store yesterday. They will find the time to do it."
That is the English subjunctive mood in a nutshell. One example I did not discuss, "Let there be light", is called the hortatory subjunctive so those above who proclaimed that "let" doesn't open up a subjunctive are wrong.