SELECT name, surname, city
from person p JOIN location USING(id)
WHERE p.id IN ( 3, 1);
-->
+----+---------+------+
|name| surname | city |
+----+---------+------+
|bill| murray | ibk |
+----+---------+------+
SELECT personid FROM persongames WHERE gameid=3;
-->
+----------+
| personid |...