need a sql script to produce a result from 2 tables

Question

Hi guys, I have been struggling witha query that is proably something simple, but I can see the wood form the trees for it.

I have two tables

 

Table 1
ID

Name

Table 2
Table1ID
Date
Task

i need to get a grid result, that will give me the next 7 das results for each name, even if nothign is in the date or task result.

 

I want this result from the current date for the next 7 days on screen,
Producing somethign like this

 

name	01/01/2018	02/01/2018	03/01/2018	04/01/2018	05/01/2018	06/01/2018	07/01/2018
bob1	task		task		task		task
bob2		task		task		task
bob3	task		task		task		task
bob4		task		task		task
bob5							task
bob6	task		task		task		task
bob7		task		task		task

A, how can I product a sql result and what is thr string to use?

Im stuck and I cant work it out.

And 2
how can I get a repeater result to show on screen.

I would like it to be a rolling screen and result tht will work on a day to day basis.

 

 

 

what query strignwould you use tog get a result like the above with empty strings next to the names and only show whats allocated?

 

Thanks in advance

Dave