Two tables, a salesman information table, a performance table to do a lookup table out below two tables are
As a result of the query table
Like

CodePudding user response:

Myself, thank you, https://bbs.csdn.net/simple_captcha? Code=0225 dcc4872d14d603021a257f97ac92b6dbcf32 & amp; Time=1521084498

CodePudding user response:

With the Access the query in
SELECT the salesman's name. The code FROM the salesman name INNER JOIN performance ON the salesman's name. Code=performance. The salesman code;

CodePudding user response:

Is not complete, select fields should be added after the performance,