Hi Stephan, Thanks a lot for the answer.
On Thu, 7 Aug 2003 15:10:00 -0700 (PDT), you wrote: >> instead of the required one. > >That is the required resultset. Union is required to do return only >one copy of a row when there are duplicates of a row. Union all returns >a number of copies equal to the number of duplicates. Right ! i forgot that :-) (blushing). Sorry. Thank you again, Silvio Scarpati ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]