This is precisely what I was looking for. 'Not In' was the key! Thank you so much.

>With this example we can do it like this.
>

>SELECT * FROM TABLE1 ;
>         WHERE FLD1.TABLE1 NOT IN ( SELECT FLD1 FROM TABLE2) ;
>         INTO TABLE RESULT
>

>But this is not with a join.
>
>>How would I do a 'non-join' :) (Would this be a part?) I want all the values from table 1 that don't exist in table2.
>>
>>I have two tables for simplicity table1 would have one field 'num' and would have numbers 1 - 20. Table2 has one field 'num' and has 1 - 15.
>>

>>Table1    table2
>>1         1
>>2         2
>>.         .
>>.         .
>>.         .
>>18        13
>>19        14
>>20        15
>>
>>The answer I want in our exaple here is:
>>
>>Query results
>>16
>>17
>>18
>>19
>>20
>>