renaming data

[robert bakaric]

hi,

how can i insert some data into table if that data is not in some second table. here is what i'm thinking about:
/
insert into tablename (GO) values ('dataxx') select ID from secondtable where secondtable.ID not in (select ID from thirdtable)
/
so i want to insert into 'tablename' 'dataxx' if 'ID' from the 'secondtable' does not exist in the 'trird table'.

dataxx is for example letter X

thank you
r