This plugin demonstrates the use of left joins and lookup tables. Code to sort data by clicking on the table head and to filter the selection set has also been added.
They are based upon a more generic system which allows creating and adding data to custom database tables from the wordpress control panel. These plugins can be used as a template for creating different types of table and display or you can just use them as they are if they do what you want to do.
Requires WordPress Version: 2.0 or higher