How to join multiple tables using join?

Question

I am trying to join multiple tables and getting data. But I am getting duplicate data. How can I resolve this? Any help.

select reliability.id,
reliability.type, 
header_id, 
header_name, 
parents.parent, 
namestates.namestate,
probabilities.probabilities
from reliability 

inner join headers
on reliability.id = headers.reliability_id 

inner join parents
on parents.reliability_id = reliability.id 

inner join definitions
on definitions.reliability_id = reliability.id

inner join namestates
on namestates.definition_id = definitions.id

inner join probabilities
on probabilities.definition_id = definitions.id

group by namestates.namestate,
probabilities.probabilities;

Answer 1

Please use left join..

select reliability.id,
reliability.type, 
header_id, 
header_name, 
parents.parent, 
namestates.namestate,
probabilities.probabilities
from reliability 

left join headers on reliability.id = headers.reliability_id 

left join parents on parents.reliability_id = reliability.id 

left join definitions on definitions.reliability_id = reliability.id

left join namestates on namestates.definition_id = definitions.id

left join probabilities on probabilities.definition_id = definitions.id

group by namestates.namestate, probabilities.probabilities;