根据条件在数据库中查询的出现三条一模一样的数据，但是在数据库中只有一条这样的数据

这是sql代码：
          SELECT 
t1.paymentRequestDataId  AS paymentRequestDataId
,t1.paymentRequestDataCode AS paymentRequestDataCode
,t1.purchaseOrderDataId AS purchaseOrderDataId
,t1.paymentWay AS paymentWay
,t1.payMoneyWay AS payMoneyWay
,t1.accountBank AS accountBank
,t1.accountName AS accountName
,t1.accountNumber AS accountNumber
,t1.createTime AS createTime
,t2.purchaseOrderCode AS purchaseOrderCode
        , t3.supplierName AS supplierName 
,t4.employeeName AS employeeName
,t5.deparmentName AS deparmentName
,t6.alreadyPayAmount AS alreadyPayAmount
,t6.prepaidAmount AS prepaidAmount
,t6.realPayAmount AS realPayAmount
,t6.comment AS comment
,t7.receiveGoodsDataCode AS receiveGoodsDataCode
,t10.contractCode AS contractCode
FROM paymentRequestData t1
LEFT JOIN purchaseOrderData t2
ON t1.purchaseOrderDataId = t2.purchaseOrderDataId
LEFT JOIN supplieMaster t3
ON t2.supplieId = t3.supplieId
   LEFT JOIN employeeMaster t4
ON t4.employeeId = t1.employeeId
LEFT JOIN deparmentMaster t5
ON t5.deparmentId=t4.deparmentId
LEFT JOIN paymentRequestDetail t6
ON  t6.paymentRequestDataId=t1.paymentRequestDataId
LEFT JOIN receiveGoodsData t7
ON t7.receiveGoodsDataId=t6.receiveGoodsDataId
LEFT JOIN purchaseOrderDetail t8
ON  t8.purchaseOrderDataId = t2.purchaseOrderDataId
LEFT JOIN contractEssentialsData t9
ON t8.cOntractEssentialsId=t9.contractEssentialsId
LEFT JOIN contract t10
ON t9.cOntractEssentialsId=t10.contractEssentialsId
WHERE t1.paymentRequestDataId = 1

出现的结果是
"1" "test001" "3" "1" "" "" "" "2016/2/1 16:15:52" "122" "广州市友昌贸易有限公司" " 祝全燕" "采购部" "" "" "" "" "" "WC160001"
"1" "test001" "3" "1" "" "" "" "2016/2/1 16:15:52" "122" "广州市友昌贸易有限公司" " 祝全燕" "采购部" "" "" "" "" "" "WC160001"
"1" "test001" "3" "1" "" "" "" "2016/2/1 16:15:52" "122" "广州市友昌贸易有限公司" " 祝全燕" "采购部" "" "" "" "" "" "WC160001"
求哪位大神帮忙解惑

3 个解决方案