L'accesoire indispensable : http://www.adafruit.com/products/1533
On 17 October 2013 16:29, dean gwilliam <mgbg25...@blueyonder.co.uk> wrote: > On 17/10/2013 14:45, Igor Tandetnik wrote: > >> On 10/17/2013 3:35 AM, dean gwilliam wrote: >> >>> On 16/10/2013 22:04, Igor Tandetnik wrote: >>> >>>> 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); >>>> >>>> Thank you very much Igor. Your answer is very much appreciated. >>> It seems that "std_name" would be better placed in another table eg >>> "std_names" and I'm not sure how you'd change the query to reflect the >>> extra table >>> >> >> select distinct name from items >> where name not in (select std_name from std_names) >> and name not in (select raw_name from aliases); >> >> -- or >> >> select distinct name from items >> where name not in ( >> select std_name from std_names >> union all >> select raw_name from aliases >> ); >> >> Igor. > Thank you very much indeed! > > ______________________________**_________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > -- Noël Frankinet Strategis sprl 0478/90.92.54 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
