I have several append queries that I would like to join into one sql query. If this is possible, I need to know the proper sql syntax to use between statements. Here are three of the queries sql statements as a sample but I have four more. The reason for so many is that I have to take several passes at the data to separate dollars and hours out of the same fields including and excluding types and dates.
INSERT INTO [FLAT FILE OUTPUT] ( ALIAS, [EV % COMPL], E, YYYMM, [BCWS T DLRS], [BCWP T DLRS], TYPE, ELEMENT_ID, RESP )
SELECT DATA.GROUP_ID_I AS ALIAS, DATA.PCT_COMPLETE AS [EV % COMPL], [ELEMENT MAP].E AS E, [PERIOD MAP].YYYMM, Sum(DATA.BUDGET_BASELINE) AS [BCWS T DLRS], Sum(DATA.EARNED) AS [BCWP T DLRS], [ELEMENT MAP].TYPE, [ELEMENT MAP].ELEMENT_ID, DATA.GROUP_ID_H
FROM (DATA INNER JOIN [ELEMENT MAP] ON DATA.ELEMENT_ID = [ELEMENT MAP].ELEMENT_ID) INNER JOIN [PERIOD MAP] ON DATA.PERIOD = [PERIOD MAP].PERIOD
GROUP BY DATA.GROUP_ID_I, DATA.PCT_COMPLETE, [ELEMENT MAP].E, [PERIOD MAP].YYYMM, [ELEMENT MAP].TYPE, [ELEMENT MAP].ELEMENT_ID, DATA.GROUP_ID_H
HAVING ((([ELEMENT MAP].TYPE)="C"));
INSERT INTO [FLAT FILE OUTPUT] ( ALIAS, [EV % COMPL], E, YYYMM, [BCWS HRS/UTS], [BCWP HRS/UTS], TYPE, ELEMENT_ID, RESP )
SELECT DATA.GROUP_ID_I AS ALIAS, DATA.PCT_COMPLETE AS [EV % COMPL], [ELEMENT MAP].E AS E, [PERIOD MAP].YYYMM, Sum(DATA.BUDGET_BASELINE) AS [BCWS HRS/UTS], Sum(DATA.EARNED) AS [BCWP HRS/UTS], [ELEMENT MAP].TYPE, [ELEMENT MAP].ELEMENT_ID, DATA.GROUP_ID_H
FROM (DATA INNER JOIN [ELEMENT MAP] ON DATA.ELEMENT_ID = [ELEMENT MAP].ELEMENT_ID) INNER JOIN [PERIOD MAP] ON DATA.PERIOD = [PERIOD MAP].PERIOD
GROUP BY DATA.GROUP_ID_I, DATA.PCT_COMPLETE, [ELEMENT MAP].E, [PERIOD MAP].YYYMM, [ELEMENT MAP].TYPE, [ELEMENT MAP].ELEMENT_ID, DATA.GROUP_ID_H
HAVING ((([ELEMENT MAP].TYPE)="H"));
INSERT INTO [FLAT FILE OUTPUT] ( ALIAS, [EV % COMPL], E, YYYMM, [ETC T DLRS], TYPE, ELEMENT_ID )
SELECT DATA.GROUP_ID_I AS ALIAS, DATA.PCT_COMPLETE AS [EV % COMPL], [ELEMENT MAP].E AS E, [PERIOD MAP].YYYMM, Sum(DATA.ACTUAL) AS [ETC T DLRS], [ELEMENT MAP].TYPE, [ELEMENT MAP].ELEMENT_ID
FROM (DATA INNER JOIN [ELEMENT MAP] ON DATA.ELEMENT_ID = [ELEMENT MAP].ELEMENT_ID) INNER JOIN [PERIOD MAP] ON DATA.PERIOD = [PERIOD MAP].PERIOD
GROUP BY DATA.GROUP_ID_I, DATA.PCT_COMPLETE, [ELEMENT MAP].E, [PERIOD MAP].YYYMM, [ELEMENT MAP].TYPE, [ELEMENT MAP].ELEMENT_ID, [PERIOD MAP].PERIOD, DATA.GROUP_ID_H
HAVING (((Sum(DATA.ACTUAL))<>0) AND (([ELEMENT MAP].TYPE)="C") AND (([PERIOD MAP].PERIOD)>[Greater than what Period]));