On Jan 15, 2008 1:04 PM, Bryan Emrys <bryan(dot)emrys(at)gmail(dot)com> wrote:
> In other words, in the sample above, I only want to return:
> 'Canada','Ireland',0
> 'Canada','Netherlands',5
Try (untested):
SELECT t2.*
FROM (SELECT payor
FROM treaty_rates
WHERE payee IN ('Netherlands', 'Ireland')
GROUP BY payor
HAVING MIN (rate) != MAX (rate)) t1
JOIN
treaty_rates t2 ON t1.payor = t2.payor
WHERE t2.payee IN ('Netherlands', 'Ireland');