Dates table

Databases
1

Hi all!
I have a table with a group name, and a day in the week for group meetings.
I want to create a query that will show me the specific dates, three monthed ahead that every group would meet.
for example:
table:
group 1 - sunday
group 2 - monday
etc…

query:
group 1 - 07/08/11
group 2 - 08/08/11
group 1-14/08/11
group 2 - 15/08/11
etc…

is it possible?
how?
Thanks a lot!
Daniel

2

any chance you can change the table? storing “sunday” makes things really difficult, but storing the actual date of the first group meeting is half way home

3

possible…what would you suggest in this case?

4 

CREATE TABLE group_dates
( group VARCHAR(99) NOT NULL PRIMARY KEY
, startdate DATE NOT NULL
);
INSERT INTO group_dates VALUES
 ('group 1' , '2011-08-07' )
,('group 2' , '2011-08-08' )