All pastes #286094 Raw Edit

Mine

public text v1 · immutable
#286094 ·published 2006-12-20 10:31 UTC
rendered paste body
SELECT DISTINCT firm.name
FROM firm, invoce, invoce AS i2
WHERE 
    date BETWEEN '2006-09-01' AND '2006-09-30' AND
    invoce.bank = firm.bank AND
    i2.bank = firm.bank AND i2.id != invoce.id AND
    (SELECT COUNT(*)
FROM pos AS p2, pos AS p1
WHERE 
p1.inv_id = invoce.id AND
p2.inv_id != pos.id AND
p1.code = p2.code AND
p1.id != p2.id
    ) = 0
;