Doing this in SQL Developer and would have thought that the INNER JOIN would be the same as the 'IN' in the bottom statement...Obviously wrong but wanna know why? Im thinking the Date is somehow causing my problem? Because when I do an equal instead of an '>=' the numbers are identical???
FROM CANC_REIN ca
INNER JOIN COVERAGE co ON ca.POLNBR = co.POLNBR
WHERE co.COV_EXPDT >= '04-JUN-09'
Order By ca.CARRID,ca.POLNBR,ca.COV_EFFDT,ca.SEQ asc;
Where POLNBR IN (Select POLNBR from COVERAGE WHERE COV_EXPDT >= '04-JUN-09')
Order By CARRID,POLNBR,COV_EFFDT,SEQ asc;