Parent Child Table Record - Building SQL Query?

Here is my table and data of these tables

Table name: Code

CID Code
1 abc
2 def
3 xyz

Table Name : Details

ID Name CID
1 a 1
2 b 2

Resultant Table:

ID Code Name
1 abc a
2 abc Null
3 def b
4 def Null
5 xyz Null
6 xyz Null

I nned to get all record from the code table and against each code I have to get all the rows from the details table, if some code have value their need value and if not then Null