On 10/16/2013 4:49 PM, dean gwilliam wrote:
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.
select distinct name from items
where not exists (select 1 from aliases where std_name = name or
raw_name = name);
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
