Relationship between Channel Views and Programme

> Do u want create relationship between this two tables ?

Yes, if possible.

> if yes tell me the relationship

Matching Channel views of 5 mins interval with the Programming Schedule. Each channel has many different programmes. Its not just the date but time as well, down to the minute. What you see here is just a snapshot. there are several thousand rows.

I need to find the Programme rankings. However the table only shows Channel Views at specfic time. I need it to somehow match the programming schedules so I can find the Programme rankings. It was an exercise introduced by a company I applied for. Maybe a relationship cannot be directly established and we may need to clean the table?

Thanks

Zac

So for example:

On the second table,

On 1st september 2016, 13:12 - 13:22, one episode of the programme AALAM GUMBALL is showing.

On the 5mins interval table, under the CNArabia channel (you can't see it from the snapshot) for 1st September 2016, there will be channel views at period 13:15 and 13.20 (5min interval). At this point, this is the snapshot of channel views for AALAM GUMBALL 13:12 - 13:22.

Is there anyway to match these? or create a relationship?

I hope this is clear enough. Thanks

Zac