On Jan 15, 2008 1:04 PM, Bryan Emrys <bryan.emrys@gmail.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');