It basically is; the technique used here is sometimes called a delayed join, which is also extremely effective on huge sorted queries.