I have three tables:
Release Date
technology_id | release_date |
---|
1 | 01/01/2010 |
Support End Date
technology_id | end_date |
---|
1 | 31/01/2011 |
Extended Support End Date
technology_id | extended_end_date |
---|
1 | 31/01/2012 |
Instead of having three tables i want to have it in following form:
technology_id | start_date | end_date | period |
---|
id | release_date | end_date | Mainstream Support |
id | end_date | extended_end_date | Extended Support |
'period' column and its values needs to be set explicitly(i do not have this in any tables).
For Example:
technology_id | start_date | end_date | period |
---|
1 | 01/01/2010 | 31/01/2011 | Mainstream Support |
1 | 31/01/2011 | 31/01/2012 | Extended Support |
I want to use this for creating gantt chart (using bar graph). I'm not able to figure out how to combine the table in above format.
Need help to figure this out please.