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
>