How to write multiple matches of join tables in mysql?

there are two tables
Table 1:
Student number 1 | Student number 2 | Student number 3
001 | 002 | 003

Table 2:
Student number | name
001 | Zhang San
002 | Li Si
003 | Wang Wu

how do I write sql statements?

Mysql-Index mysql-optimized sql-statement mysql sql

Jul.19,2021

I don't know what kind of watch design this is, but I'll give you my answer.
Table 1 / table b1, Table 2 = b2

select 
    b1.sid1,
    b2-1.name,
    b1.sid2,
    b2-2.name,
    b1.sid3,
    b2-3.name 
from 
b1 
left join b2 as b2-1 on b1.sid1=b2-1.sid
left join b2 as b2-2 on b1.sid2=b2-2.sid
left join b2 as b2-3 on b1.sid3=b2-3.sid;

Previous: How does Python add a file by field and find the mean?

Next: The local component of vue router simulates the switching process of a single page, and the event method in the component cannot destroy the problem.

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e38609-4449e.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e38609-4449e.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?