mysql> select product_type.description type, vendor.description vendor, product.description product,version.description version from product left join vendor on vendor.id = product.vendor_id left join product_type on product_type.id = product.type_id left join version on version.product_id = product.id order by type,vendor,product,version; +------------------+--------------------+--------------------------+----------------------------+ | type | vendor | product | version | +------------------+--------------------+--------------------------+----------------------------+ | Control Panel | cPanel | cPanel | STABLE | | Control Panel | Ensim Corporation | Ensim Pro for Linux | 10 | | Control Panel | Ensim Corporation | Ensim Pro for Windows | 10 | | Control Panel | SWsoft | Plesk for Linux/Unix | NULL | | Control Panel | SWsoft | Plesk for Windows | NULL | | Control Panel | WebHost Automation | Helm | 3 | | Control Panel | WebHost Automation | Helm | 4 | | Operating System | CentOS Project | CentOS | 4 | | Operating System | CentOS Project | CentOS | 5 | | Operating System | Debian Project | Debian | 3 | | Operating System | Debian Project | Debian | 4 | | Operating System | FreeBSD Foundation | FreeBSD | 5.4 | | Operating System | FreeBSD Foundation | FreeBSD | 5.5 | | Operating System | FreeBSD Foundation | FreeBSD | 6.0 | | Operating System | FreeBSD Foundation | FreeBSD | 6.1 | | Operating System | FreeBSD Foundation | FreeBSD | 6.2 | | Operating System | Microsoft | Windows | 2000 Advanced Server | | Operating System | Microsoft | Windows | 2000 Server | | Operating System | Microsoft | Windows | 2003 Enterprise Edition | | Operating System | Microsoft | Windows | 2003 Small Business Server | | Operating System | Microsoft | Windows | 2003 Standard Edition | | Operating System | Red Hat | Enterprise Linux | 3 AS | | Operating System | Red Hat | Enterprise Linux | 3 ES | | Operating System | Red Hat | Enterprise Linux | 4 AS | | Operating System | Red Hat | Enterprise Linux | 4 ES | | Operating System | Red Hat | Enterprise Linux | 5 | | Operating System | Red Hat | Enterprise Linux | 5 Advanced Platform | | Operating System | Red Hat | Fedora | Core 5 | | Operating System | Red Hat | Fedora | Core 6 | | Operating System | Red Hat | Fedora | Core 7 | | Statistics | Google | Urchin | 5 | | Virtualization | SWsoft | Virtuozzo for Linux/Unix | NULL | | Virtualization | SWsoft | Virtuozzo for Windows | NULL | +------------------+--------------------+--------------------------+----------------------------+ 33 rows in set (0.00 sec)