Query conditions and correlation of two pieces of the main table: find out two tables the same conditions of associated data

Want to achieve the result is as shown in the figure below

List the main table following query

 
Class, name, select a. a. a. and b. teacher 
From table 1 on a left join teacher list b a.f id=b. id 
Where b. Teacher Chen in 3 

CodePudding user response:

Table 1 which field is fid, why don't the query teacher that field,

CodePudding user response:

reference 1st floor RINK_1 response:

table 1 which field is fid, why don't the query teacher that field,

Each table has a FID fields, can be used

CodePudding user response:

refer to the second floor heart and reply:

Quote: refer to 1st floor RINK_1 response:

Table 1 which field is fid, why don't the query teacher that field,

Each table has FID fields, can use the

The fields are associated with teacher to try