表A
A1 A2 A3 A4
01 02 03 04
03 04 01 02
表B
B1 B2
01 张三
02 李四
03 王五
04 赵六
显示结果
A1 A2 A3 A4
张三 李四 王五 赵六
王五 赵六 张三 李四
SELECT
(SELECT B2 FROM B WHERE B1=A1) AS A1,
(SELECT B2 FROM B WHERE B1=A2) AS A2,
(SELECT B2 FROM B WHERE B1=A3) AS A3,
(SELECT B2 FROM B WHERE B1=A4) AS A4
FROM A
结果如下:
<img src="https://img-blog.csdn.net/20151106155339152?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQv/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center" alt="" />
SQL SERVER 表与表之间 字段一对多
最新推荐文章于 2024-06-17 20:44:56 发布