Yes you can do it. What you looking for is called
Join
Here is very brief intro
http://www.w3schools.com/sql/sql_join.asp[
^]
the example assumes what your tables may look like. You need to adjust it to fit your design.
SELECT first_name, family_name, lesson_name
FROM students s
INNER JOIN lessons l
ON s.id = l.id