您好开发人员我有两个表,通过mysql join合并,获取多行而不是单行,请解决此问题,
tbltestdefault
-----------------------------------------------
ID Test_ID Description
-----------------------------------------------
1 117 Blood Group
2 117 Rh Factor
3 4 HB
4 4 RBC
5 4 ESR
tblreportdetail
-----------------------------------------------
ID Test_Default_ID Result_Value
-----------------------------------------------
1 117 A
2 117 Positive
3 4 12
4 4 15
5 4 25
我的查询是
SELECT a.Description,
b.Result_Value
from tbltestdefault a
inner join tblreportdetail b on a.Test_ID = b.Test_Default_ID
该查询返回多行
以上查询结果
tblreportdetail
Description Result_Value
HB 12
HB 15
HB 25
HB 12
RBC 15
RBC 25
RBC 12
RBC 15
ESR
ESR
ESR
ESR
Blood Group
Blood Group
Blood Group
Blood Group
Rh Factor
Rh Factor
Rh Factor
Rh Factor
解决方法:
他们不是骗子.您得到的正是您想要的.如果您将两个表格ID添加到查询中,则会看到它们不是重复的,例如
Description Result_Value a.id b.id
HB 12 3 3
HB 15 3 4
HB 25 3 5
HB 12 4 3
HB 15 4 4
HB 25 4 5
etc...
标签:join,mysql
来源: https://codeday.me/bug/20191121/2050666.html