List values from a table that are not present in another table

[kolorasta]

-table1
-field1, field2-
a, letra_a
b, letra_b
c, letra_c
d, letra_d

table2
-field1
b
c

OUTPUT wanted
letra_a
letra_d

I want to output all rows in table1 with the values not present in table2.

sorry for my poor english

 

[RoyVidar]

Try:

[tt]select table1.field2
from table1 left join table2 on
table1.field1 = table2.field1
where table2.field1 is null[/tt]

Roy-Vidar