mysql> select h.name, i.* from interface i inner join hosts h on h.hostid = i.hostid;
+---------------+-------------+--------+------+------+-------+---------------+-----+-------+------+
| name          | interfaceid | hostid | main | type | useip | ip            | dns | port  | bulk |
+---------------+-------------+--------+------+------+-------+---------------+-----+-------+------+
| Zabbix server |           1 |  10084 |    1 |    1 |     1 | 127.0.0.1     |     | 10050 |    1 |
| xxxxxxxxxxxxx |           2 |  10105 |    1 |    1 |     1 | 192.168.xx.xx |     | 10050 |    1 |
| test          |           4 |  10106 |    1 |    1 |     1 | 127.0.0.1     |     | 10050 |    1 |
+---------------+-------------+--------+------+------+-------+---------------+-----+-------+------+
3 rows in set (0.00 sec)

mysql> select h.name, i.* from interface i inner join hosts h on h.hostid = i.hostid;
+---------------+-------------+--------+------+------+-------+---------------+-----+-------+------+
| name          | interfaceid | hostid | main | type | useip | ip            | dns | port  | bulk |
+---------------+-------------+--------+------+------+-------+---------------+-----+-------+------+
| Zabbix server |           1 |  10084 |    1 |    1 |     1 | 127.0.0.1     |     | 10050 |    1 |
| xxxxxxxxxxxxx |           2 |  10105 |    1 |    1 |     1 | 192.168.xx.xx |     | 10050 |    1 |
| test          |           5 |  10106 |    1 |    1 |     1 | 127.0.0.2     |     | 10550 |    1 |
+---------------+-------------+--------+------+------+-------+---------------+-----+-------+------+
3 rows in set (0.00 sec)

mysql>