SELECT [forgings annual inventory detail - query] [storage year], [forgings annual inventory detail - query]. [the total number of incoming]
Annual inventory detail FROM [forging - query];

UNION ALL

SELECT [forgings warehousing detail - query each year - 511 order]. [storage year], [forgings warehousing detail - query each year - 511 order]. [the total number of incoming]
FROM [forgings warehousing detail - query each year - 511 order].

According to the following:

Incoming year into the Treasury of total quantity
2019, 211258,
2020, 41349,
2018, 134374,
2019, 491390,


SELECT [forgings annual inventory detail - query] [storage year], [forgings annual inventory detail - query]. [the total number of incoming]
Annual inventory detail FROM [forging - query];

UNION ALL

SELECT [forgings warehousing detail - query each year - 511 order]. [storage year], [forgings warehousing detail - query each year - 511 order]. [the total number of incoming]
FROM [forgings warehousing detail - query each year - 511 order].

GROUP BY year [Treasury];


Increased after a day GROUP, as shown in the SQL statement after find characters,
ACCESS database

Consult everybody a great god

CodePudding user response:

First try ; remove:

.
Annual inventory detail - query FROM [forging - not work order 511] ;
GROUP BY year [Treasury];