How can I create a basic fade transition effect between two videos?

Let us say we have video1.mov playing and after that is done, play video2.mov right away.

But when video1 is done playing, the last few seconds, the frames fade out and when video2 starts playing, the first few frames fade in.