1.SQL01
TA
| Code1 | Code2 |
| 01 | 02 |
| 02 | 03 |
| 03 | 01 |
TB
| Code | Name |
| 01 | AA |
| 02 | BB |
| 03 | CC |
| 04 | DD |
| 05 | EE |
TA要达到的效果：
| Name1 | Name2 |
| AA | BB |
| BB | CC |
| CC | AA |
方法1：
SELECT
(SELECT TB.Name FROM TB WHERE TB.Code = TA.Code1) AS Name1,
(SELECT TB.Name FROM TB WHERE TB.Code = TA.Code2) AS Name2
FROM TA
方法2：
SELECT B1.Name AS Name1,B2.Name AS Name2
FROM TA
INNER JOIN TB B1 ON B1.Code = TA.Code1
INNER JOIN TB B2 ON B2.Code = TA.Code2
方法3：
SELECT B1.Name AS Name1,B2.Name AS Name2
FROM TA,TB AS B1,TB AS B2
WHERE TA.Code1 = B1.Code AND TA.Code2 = B2.Code
0 Comments.