Frankly, this one patent is worth a lot of money. This is the magic by which Looker casts out duplicate records in joins.

http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=H...