Left Outer Join doesn't give expected result. What am I missing? My objective is to find records that exist in Table 1 but do not exist in Table2. No record has a NULL value. 
I am using the following code, but it is not giving me the expected results. 

Select  
    distinct a.fld  
from  
    tbl1 a  
left outer join 
    tbl2 b 
on  
    a.fld= b.fld
where  
    a.fld&lt;&gt; b.fld


Most likely the issue is with my where clause, but I can't seem to figure out what the issue is. Pls Help.
Assuming "Table 1" is tbl1a, this should give you what you want:

SELECT DISTINCT a.fld
FROM tbl1 a
LEFT JOIN tbl2 b ON a.fld = b.fld
WHERE b.fld IS NULL