>>> On Mon, Aug 13, 2007 at 4:30 PM, in message <46C0CD72.5090407@xxxxxxxxx>, "olivier.boissard@xxxxxxxxx" <olivier.boissard@xxxxxxxxx> wrote: > So it's like a filter on the first query Exactly; I think that sums it up better than anything I said. By the way, it does strike me as an odd omission that there is no set operator in the ANSI standard to get you directly to the set of disjoint elements. With two datasets, a and b, you could always get there with: (a EXCEPT b) UNION ALL (b EXCEPT a) or with: (a UNION ALL b) EXCEPT (a INTERSECT b) Of course, you could store the sets in temporary tables to get there without generating from scratch each time, if that is expensive. -Kevin ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
