Programming

Table `os`:
+--------------------------------+
| id | distro       | version    |
+--------------------------------+
| 1  |  CentOS      |  5.2       |
| 2  |  RHEL        |  5         |
| 3  |  RHEL        |  4         |
+--------------------------------+


Table `admins`:
+----------------+
| id |    title  |
+----------------+
| 1  | Trovalds  |          
| 2  | Stallman  |
| 3  | Housni    |
+----------------+


Table `servers`:
+------------------------+
| id |  title   |  os_id |
+------------------------+
| 1 |  Portal   |  1     |
| 2 |  Staging  |  1     |
| 3 |  Live     |  3     |
+------------------------+


I have a table `server_admin` which holds two foreign keys: server_id and admin_id
+----------------------+
| server_id | admin_id |
+----------------------+
|     1     |    1     |
|     1     |    3     |
|     1     |    4     |
|     2     |    7     |
|     3     |    2     |
+----------------------+

SELECT CONCAT_WS( ' - ', `servers`.`title` AS `origname`, (
        SELECT CONCAT_WS( ' - ', `distro`, `version` ) AS `disver` 
        FROM `os` , `servers` 
        WHERE `os`.`id` = `servers`.`id` AND `servers`.`title` = `origname`) 
) AS `servname`, `server_admin`.`server_id` 
FROM `server_admin`, `servers`
WHERE (`server_admin`.`server_id` = `servers`.`id`)
GROUP BY `servers`.`title`;

SELECT [required fields from all tables]
FROM [all tables]
WHERE `server_admin`.`server_id` = `servers`.`id` AND `server_admin`.`admin_id` = `admins`.`id` AND `servers`.`id` = `os`.`id`
GROUP BY `servers`.`title`;