USE T202425

SELECT COUNT(VOUNO),VOUSUPPCODE,VOUCUSTCODE,SUPPBILLNO FROM PURCHASE_DETAIL GROUP BY VOUSUPPCODE,VOUCUSTCODE,SUPPBILLNO  HAVING COUNT(VOUNO)>1

SELECT * FROM SUPPLIER_MASTER WHERE SUPPCODE = '18CH005'
SELECT * FROM CUSTOMER_MASTER WHERE CustCode = '18DX001'