Re: SQL dealing with subquery

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');