求一句sQL,在线等待

[山尖美色]

SELECT * FROM PUM11,PUM12,PUM16　
WHERE PUM11.SRNO1=PUM12.SRNO1
and PUM11.SRNO2=PUM12.SRNO2
and PUM11.SRNO3=PUM12.SRNO3
and PUM11.TX_SEQ=PUM12.TX_SEQ
AND PUM11.SEND_ORGAN_CODE='FA01B026G'
and PUM16.SRNO1=PUM11.SRNO1
and PUM16.SRNO2=PUM11.SRNO2
and PUM16.SRNO3=PUM11.SRNO3
and PUM16.TX_SEQ=PUM11.TX_SEQ　

pum11,pum16的主键为srno1,srno2,srno3,tx_sql
而pum12的主键为srno1,srno2,srno3,tx_sql，srcid

求不会重复的记录

[heixiu1980]

加个distinct不行么？

[山尖美色]

加distinct只能对单个字段呀！我要select 多个字段

[heixiu1980]

一样的！

[smallcrocodile]

关注

[smallcrocodile]

你的结果什么重复了

[pengdali]

SELECT distinct * FROM PUM11,PUM12,PUM16
WHERE PUM11.SRNO1=PUM12.SRNO1
and PUM11.SRNO2=PUM12.SRNO2
and PUM11.SRNO3=PUM12.SRNO3
and PUM11.TX_SEQ=PUM12.TX_SEQ
AND PUM11.SEND_ORGAN_CODE='FA01B026G'
and PUM16.SRNO1=PUM11.SRNO1
and PUM16.SRNO2=PUM11.SRNO2
and PUM16.SRNO3=PUM11.SRNO3
and PUM16.TX_SEQ=PUM11.TX_SEQ

或

SELECT 所有字段 FROM PUM11,PUM12,PUM16
WHERE PUM11.SRNO1=PUM12.SRNO1
and PUM11.SRNO2=PUM12.SRNO2
and PUM11.SRNO3=PUM12.SRNO3
and PUM11.TX_SEQ=PUM12.TX_SEQ
AND PUM11.SEND_ORGAN_CODE='FA01B026G'
and PUM16.SRNO1=PUM11.SRNO1
and PUM16.SRNO2=PUM11.SRNO2
and PUM16.SRNO3=PUM11.SRNO3
and PUM16.TX_SEQ=PUM11.TX_SEQ group by 所有字段

[山尖美色]

多了一倍的记录

[heixiu1980]

加了distinct 不会出现完全重复的记录，你仔细看看，肯定有字段不同的。

[pengdali]

SELECT * FROM PUM11,PUM12,PUM16
WHERE PUM11.SRNO1=PUM12.SRNO1
and PUM11.SRNO2=PUM12.SRNO2
and PUM11.SRNO3=PUM12.SRNO3
and PUM11.TX_SEQ=PUM12.TX_SEQ
AND PUM11.SEND_ORGAN_CODE='FA01B026G'
and PUM16.SRNO1=PUM11.SRNO1
and PUM16.SRNO2=PUM11.SRNO2
and PUM16.SRNO3=PUM11.SRNO3
and PUM16.TX_SEQ=PUM11.TX_SEQ

select @@rowcount 记录数

SELECT distinct * FROM PUM11,PUM12,PUM16
WHERE PUM11.SRNO1=PUM12.SRNO1
and PUM11.SRNO2=PUM12.SRNO2
and PUM11.SRNO3=PUM12.SRNO3
and PUM11.TX_SEQ=PUM12.TX_SEQ
AND PUM11.SEND_ORGAN_CODE='FA01B026G'
and PUM16.SRNO1=PUM11.SRNO1
and PUM16.SRNO2=PUM11.SRNO2
and PUM16.SRNO3=PUM11.SRNO3
and PUM16.TX_SEQ=PUM11.TX_SEQ

select @@rowcount 记录数

[山尖美色]

pengdali(大力) 不管用呀！