List off all hosts

[karl.otte]

I need to assemble a list of all hosts with their respective nodes by Mysql.

Eg:

HOST | NODE
HOSTA | NODE1
HOSTB | NODE1
HOSTC | NODE2
HOSTD | NODE3

I could not find the relationships between tables in mysql. Can you help?