1. A method comprising: receiving a query in a join processor; and using said join processor to: evaluate local predicates from said query of an outer full text index to generate a first posting list of documents; determine the value of a join attribute from said query for each document in said first posting list; probe an inner full text index to obtain a second posting list of documents containing one of said join attributes determined for each said document; evaluate local predicates of an inner full text index to generate a third posting list of documents; merge said second posting list with said third posting list to generate a merge list of documents; and pair up each document in said first posting list with documents in said merge list.