"Ray Madigan" <[EMAIL PROTECTED]> writes: > Is there any way to use except that won't remove the non-distinct rows from > the left side of the query?
EXCEPT ALL might or might not do what you're hoping for. Check the manual (I think the SELECT reference page is what to look at). regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend