One query, three linked tables.

Barbara's suggestion about the actual relationships (aha! this is something the books don't mention, at least not in the place where you'd think they'd mention it) has changed it up a little, but still not showing everything I need. It's a start, though........