I want to get the debtors additional address with a specific id. 

**debtors**

```
id hnr place      name
1  22  Amsterdam  companyname
2  26  Enschede   anotherCompany

```

**aditional\_debtor**

```
id debtors_id hnr place 
1  1          12  Almelo

```

**Result when I select on like debtors.name %companyname%**

```
hnr debtors.id  place       name
22  1           Amsterdam   companyname
12  1           Almelo      companyname

```

My query till now:

```
SELECT * FROM debtors d where d.name LIKE '%companyname%'; 

```

But how can I join the other table to get the additional addresses and the "default" address from the debtors table (The default address must be the first row in the result set).