>This seems as if it is a simple problem, but I have had no luck looking for a solution.
>
>There are two unindexed tables
>Table 1 is a list of words.
>Table 2 is the same list but some words from table1 are missing from table 2
>How do I find and show the words that are missing from table 2 by comparing table1 to table2?
SELECT Table1.*;
FROM Table1;
LEFT JOIN Table2 ON Table1.WordField = Table2.WordField;
WHERE Table2.WordField IS NULL
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
