Joining to child data which may or may not have data for each record in parent table

Question

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.

Use `left join` instead of `join` or `inner join` – juergen d May 25 '15 at 10:09 — juergen d, May 25 '15 at 10:09
Please show the query that you ran. – Sergey Kalinichenko May 25 '15 at 10:10 — Sergey Kalinichenko, May 25 '15 at 10:10

wiretext · Answer 1 · 2015-05-25T10:13:36.667

0

SELECT column_name(s)
FROM table1
LEFT JOIN table2
ON table1.column_name=table2.column_name;

edited May 25 '15 at 10:13

answered May 25 '15 at 10:10

wiretext

3,302
14
19

@jarlh Sorry Updated :) – wiretext May 25 '15 at 10:14

score 0 · Answer 2 · answered May 25 '15 at 10:10

0

Simply use join here(left outer join or right outer join)

SELECT * FROM tbl1
LEFT OUTER JOIN tbl2 ON tbl1.Column=tbl2.Column

answered May 25 '15 at 10:10

Mike Clark

1,860
14
21

Joining to child data which may or may not have data for each record in parent table

2 Answers2