Thanks, everyone.

From what I understand the derived table is more effiecient.  It took me a while to understand them, though.  The instructor I had when working on my degree taught us to do everything with sub-queries.  The class was actually on PL SQL (Oracle's version) and some of the features are different.