mysql> select * from tblAdvertisementTypes; +---------------------+---------------------------+------------------+-------------------------+ | AdvertisementTypeID | Name | Description | AdvertisementCategoryID | +---------------------+---------------------------+------------------+-------------------------+ | 1 | Audio Insertion | OrderSpotblocks | 3 | | 2 | Audio Insertion /w Banner | OrderSpotblocks | 3 | | 3 | Audio Gateway | OrderImpressions | 2 | | 4 | Video Gateway | OrderImpressions | 2 | | 5 | Banner | OrderClickthrus | 1 | | 6 | Audio Gateway /w Banner | NULL | 2 | | 7 | Third-Party Banner | OrderClickthrus | 1 | | 8 | Third-Party Gateway | OrderImpressions | 2 | | 9 | Video Gateway w/ Banner | NULL | 2 | +---------------------+---------------------------+------------------+-------------------------+ mysql> select * from tblAdvertisementCategories; +-------------------------+-----------+ | AdvertisementCategoryID | Name | +-------------------------+-----------+ | 1 | Banner | | 2 | Gateway | | 3 | Insertion | +-------------------------+-----------+