I have two tables a Master and Child. I want to return a recordset that has all of the Master records and any related child values.
'id' 'masterID' 'field1'
1 2 Child1The following code will only return one record:
SELECT master.id, master.field1, child.field1 FROM master INNER JOIN child on master.id = child.masterID WHERE child.id = 1
What I need to achieve is:
I hope that makes sense. I am not even sure if it is possible.
I have tried using various OUTER JOIN combinations but the result is the same.