Questions about database foreign key and primary key query

It is not long before you learn about the database foreign key and primary key query. Ask the Experts: Table A has the ID and name, and Table B has the ID and score, the ID of Table B is the foreign key of Table A. How can we get the score by finding the name of Table !, SelectB. fenshufromAjoinBONA. id = B. idwhereA. name = 'Zhang San'; database foreign key and primary key query problems
It wasn't long before I learned about the database:
Table A has the ID and name, Table B has the ID and score, and Table B's ID is the foreign key of Table A. How can we get the score by finding the name of Table!

------ Solution --------------------
Select B. fenshu from A join B on a. id = B. id where A. name = 'Zhang San ';