How to join three tables

Wed, 30 Sep 2015 08:49:44 GMT

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.

topic How to join three tables in QlikView