View Single Post

   
  #5 (permalink)  
Old 04-24-2008, 06:07 PM
Plamen Ratchev
 
Posts: n/a
Default Re: Use of having with additional select

I agree with Hugo that the information you provided is not sufficient to
give you a good answer. Here is just a guess based on your explanation and
expected results:

SELECT C.cerveh, C.monto1, A.prima
FROM Arysauto AS A
JOIN (SELECT ramo, cerveh, poliza, stcdcb,
SUM(monto1) AS monto1
FROM Clpf08
GROUP BY ramo, cerveh, poliza, stcdcb) AS C
ON A.cerveh = C.cerveh
WHERE C.ramo = 31
AND C.poliza = 6100265
AND C.stcdcb = ' '
AND EXISTS (SELECT *
FROM Clpf07 AS B
WHERE B.ramo = C.ramo
AND B.poliza = C.poliza
AND B.cerveh = C.cerveh
AND B.actret <> 'R')
AND C.monto1 - A.prima > 0;

HTH,

Plamen Ratchev
http://www.SQLStudio.com

Reply With Quote