SELECT a.id,a.score_id,a.fname,a.age,a.school,b.verbal,b.math,b.english FROM users AS a LEFT JOIN score AS b ON a.score_id = b.score_id
转换
SELECT a.id,a.score_id,a.fname,a.age,a.school,b.verbal,b.math,b.english FROM users AS a LEFT JOIN score AS b ON a.score_id = b.score_id
转换