**I am just beginner learning database php mysql and I am confused what join should I use in this. I have my foreign key which is the ExamineeID and I want these both table to be join together. But I do not know how to do it nor what join should I use. These are my tables: **
I want to join them both, and it is okay if the ScoreID is not on the table, but the most important that can be included is the Score, Rank, ExamTime, ExamineeID and all of the columns in Table 1.