• You could be right but the FTI wouldn't be on Table 2 according to the OPs latest post. It would only be needed on Table 1. Fortunately, I don't see any requirements to join Table 1 to Table 2 under such conditions.

    Wasn't the requirement to search the rows in Table2 for those that matched a row in Table1? That was how I read it.