Be careful, though, when using minus -- it will remove duplicate rows. This may be exactly the behavior you want, but you should at least consider what you're asking the database to do... If those rows are interesting to you, then minus isn't such a good candidate for comparisons. On 3/22/06, Juan Carlos Reyes Pacheco <juancarlosreyesp@xxxxxxxxx> wrote: > The minus technique is the best I think to compare tables, but I think > attractive the idea of the hash column. <snip> Glenn -- //www.freelists.org/webpage/oracle-l