Exclude Rows

Table 1 is just a reference table. Users add values to table 2.





I need to select/exclude records from table1 where the id2 in table2 = 1.





How get the following results:








table 1


----------


id


----------


a


b


c


d


e


f


g








table 2


----------


id / id2


----------


b / 1


c / 1


d / 1


f / 1


c / 2


d / 2


a / 4


b / 4








need results


----------


id


----------


a


e


g








any suggestions?








thanks