tbl_invoice_challan
SELECT challanid FROM tbl_invoice_challan GROUP BY challanid HAVING COUNT(DISTINCT invoiceid) > 1
SELECT * FROM Test AS zd WHERE (SELECT count(*) FROM Test AS t1 WHERE = zd.liefschnum AND t1.pos = zd.pos) > 1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)