A great god, please help take a look at the statement should be how to write?
Thank you very much!

CodePudding user response:

Select * from table 1 a left join table 2 b on a. name=b. name

CodePudding user response:

The most simple connection

CodePudding user response:

Select the table 1. The student id, table 1. Name, table 2. Performance
From table 1 left the join table 2
On table 1. Table name=2. Name