vl.pavlov wrote:
>
> i wander how to do this query:
>
> insert into tablename values ('word')
> but if does not exist the same word in other table
> I'm not sure if this is what you are asking, but you can try this: insert into tablename select :word where not exists (select word from other_table where word = :word) HTH Dennis Cote _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
