1. A computer hardware implemented method comprising: receiving a query by a processor, the query comprising: an inner full text index which comprises a first set of document ids, each of the documents ids having a first attribute and a first value; an outer full text index which comprises a second set of document ids, each of the documents ids having a second attribute and a second value; one or more inner local predicates comprising a first search term for the inner full text index; one or more outer local predicates comprising a second search term for the outer full text index, an inner join attribute comprising a third search term corresponding to the first value; and an outer join attribute comprising a fourth search term corresponding to the second value; and using said processor to: evaluate the one or more outer local predicates from said query of the outer full text index to generate a first posting list of documents; determine the second value of the outer join attribute from said query for each document in said first posting list; probe the inner full text index to obtain a second posting list of documents containing one of said inner join attributes determined for each document in said first posting list; evaluate the one or more inner local predicates of the 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.