Table A             TABLE B (has fk of A)               TBALE C (HAS FK OF B)
aid aname            bid bname afk                  cid  cname bfk
1  a                 1   b      1                   1     c     1
2  a2                2   b2     2                   2     c2     1

select a.aname , b.bname , c.cname from A a
left join B b
on a.aid = b.afk
left  join C c
on c.bfk = b.bid;