i am new to LINQ and joins, so Please forgive me if I am asking it wrong.
I have two tables

**Table1**

```
id   name    date
1    Mike    20-10-15
2    John    21-10-15
3    Sam     23-10-15

```

**Table2**

```
id   name   date
1    Ashle  19-10-15
2    Lily   21-10-15
3    Jeni   22-10-15
4    April  23-10-15

```

I need 5 records using Joins and should be orderby Date, most recent records.

Can you guys help me, I really need to figure out how Joins works with orderby.
Thanks

**EDIT:**
They are two different tables so no foreign key, so I think I can't use Join, so so far what I have done is like this

```
var combinddata = (from t1 in db.Table1
                        select t1.id)
                            .Concat(from t2 in db.Table2
                                    select t2.id);

```

I don't know how to get only 5 records how to compare records from both tables on DateTime base.

**Output should be**

1. Sam
2. April
3. Jeni
4. John
5. Lily