query with 3 tables
I have 3 tables: on the first, I have the names of the people, on the second, the names of the courses, and on the third, the courses that people are taking.
tab_first
-------------------
id name
1st
2b
tab_second
--------------------
id description
1 course x
2 course y
tab_third
---------------------
id_people id_course
1 1
2 1
2 2
I would like a query that produces the following result:
Person Course X Course Y
------------------------------------------------
to X
b X X
Is this possible?