There are two tables (came sales TAB) and B (store brand sales summary), structure is shown in figure:





To achieve the effect of the A, B two table statistics list megabite=famous brand shoe shoe kind of column and, because the list of industry only six:
Famous brand shoe shoe kind, the fair maiden outfit industry, few women's clothing industry, men's toy industry, sports leisure industry, household life industry,
So A query results should be six, table B query results should be six, I want to put the two results according to the industry name in the order table that joining together,

Total amount to be, number of orders came pen, collect transaction value of the format,
Test now famous brand shoe shoe kind of the result of A table right, B table is A record value should be 100, and now do not know from which A 9500 excuse me, where is write wrong?

CodePudding user response:

Filter condition not
Put one query out ah, you are like this who know where you are wrong

CodePudding user response:

Are you two tables respectively according to the industry of first GROUP summary it is concluded that the two result sets, and then two result set by association of industry of