I have the following entities: Trackings, Ranks

Each Tracking can have 0 or more Ranks. Each Rank has a property called RankDateTime.

I need to find all trackings that have no ranks for today.

This is what I have been trying:

Attempt 1

```
var myTrackings = from track in DBContext.Trackings
            join r in DBContext.Ranks on track.TrackingId equals r.TrackingId
            where r.RankDateTime < DateTime.Today select track;

```

Attempt 2

```
var myTrackings3 =
DBContext.Trackings.Where(t => t.Ranks.Any
(r => r.RankDateTime.Date != DateTime.Today.Date));

```

I'm a bit confused here and my intuition is telling me I'm doing something wrong here.

What's the correct way of querying this?

Thanks in advance.