I have two tables as given below

    Table A                Table B             Table C              
  =============          ==============        =========
    Id    Name           Id   AId  CId         Id   Name 
    1     A              1    1    1           1    x
    2     B              2    1    1           2    y
    3     C              3    2    1           3    z 
    4     D              4    2    3           4    w
    5     E              5    3    2           5    v

Now I want all the records of Table A with matching Id column CId from Table B where CId = 1.

So the output should be like below :

Id Name CId
1   A   1 
2   B   1
3   C   1
4   D   Null
5   E   Null

Can anyone help me please?