I'm just wondering...
if I have two tables
1 aliases (std_name, raw_name)
2 items (name......)
what would the query look like to select all "name" fields in "itms"
that match neither "std_name" or "raw_name" in "aliases"
and where the resulting list of "name"s contains no duplicates.
I ask because I want to add these "name"s (in items) to the "raw_name"
column in "aliases"
I hope I've explained my self clearly and any help much appreciated.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
