mysql - 如何合并两个表并连接两个值

Question

我有这两张表

tbl_Output

    ref_id1 | desc1 | rec_type
       1     value1      1     
       1     value2      2  



tbl_Output2

    ref_id2 | desc2 | rec_type
        1      value3     1
        1      value4     2

如何连接这两个表？显示

ref_id1 | desc1  | ref_id2 | desc2  | rec_type
   1      value1      1      value3      1
   1      value2      1      value4      2

而不是

ref_id1 | desc1  | ref_id2 | desc2  | rec_type
   1      value1      1      value3      1
   1      value2      1      value4      2
   1      value1      1      value3      1
   1      value2      1      value4      2

Here is my Query:
SELECT *
  FROM tbl_Output1 as O
  inner JOIN tbl_Output2 as O2 on
  O.ref_id1 = O2.ref_id2

注意:我已经使用了不同类型的连接。

Answer 1

尝试加入id1/id2列和rec_type栏目:

SELECT t1.ref_id1,
       t1.desc1,
       t2.ref_id2,
       t2.desc2,
       t1.rec_type
FROM tbl_Output t1
INNER JOIN tbl_Output2 t2
    ON t1.ref_id1 = t2.ref_id2 AND
       t1.rec_type = t2.rec_type

此处演示:

SQLFiddle