Select Kahe tabeli põhjal

SELECT lp.nimi as 'Lapse nimi', l.nimi as 'Looma nimi', l.kaal, lp.synnilinn 
FROM laps as lp RIGHT JOIN loom as l
ON l.lapsID = lp.lapsID;