I wish to cast a query in two tables, but the result set should show only all results from the first table with the info from the second table linked with the first one, but there are many linked info, i just want the last linked information. eg

table 1

```
id_t1 | number | type
1        555     file
2        666     img

```

table 2

```
id_t2 | id_table1_fk | date_in | description
1        1             04/07       aaaaaaa
2        1             05/07       bbbbbbb

```

query

```
id_t1 | number | type | date_in | description
1        555     file     05/07     bbbbbbb
2        666     img       null      null

```