SELECt
Table_1.*,
g.Name,
m.Name
FROM
Table_1
INNER JOIN Table_2 AS g ON Table_1.Group=g.ID
INNER JOIN Table_2 AS m ON Table_1.Group=m.ID
WHERe
Table_1.Group=2
AND Table_1.Member=7
SELECt
Table_1.*,
g.Name,
m.Name
FROM
Table_1
INNER JOIN Table_2 AS g ON Table_1.Group=g.ID
INNER JOIN Table_2 AS m ON Table_1.Group=m.ID
WHERe
Table_1.Group=2
AND Table_1.Member=7
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
