sql - Large inner join -

itemprop = "text">

We have 2 tables with the English word: with the word 1 and word 2 fields (the word referrals as VARCHAR, INT ), Where the word - this is an English word, referee - reference to the second (third) table (this is not important).

All the words in each table are unique. In the first table there are some words that are not in the other (and vice versa are some unique words in the second table).

But most of the words in the two tables are similar.

Need to get: Results table with all the specific words and referees.

Initial Conditions

1. The referee may be different for the same table
2. Each table contains 300 000 words Is counted, hence the inner is not going to be included

example

  word 1 ________ health-1 car -3 Speed-5 word 2 _________ health-2 tote-6 fast-8 speed-9 results table _____________ health-1 car -3 speed -5 booty -6 fast -8  
 
 , min (referee) Word from