I have table 1 and table2.
In table we have basic participant information.

In table 2 we will have special info of participant (All the participants may not have the special info so they don't have record in table 2).

Now I want to join the two tables based on participantid, am able to get only the info if we have data in both tables but I need all the participant info who don't have special info.