Re: [sqlite] select all fields of a column in one table that are not in a column in another table

2013-10-17 Thread dean gwilliam
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

Re: [sqlite] select all fields of a column in one table that are not in a column in another table

2013-10-17 Thread Igor Tandetnik
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

Re: [sqlite] select all fields of a column in one table that are not in a column in another table

2013-10-17 Thread dean gwilliam
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

Re: [sqlite] select all fields of a column in one table that are not in a column in another table

2013-10-17 Thread Noel Frankinet
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

Re: [sqlite] select all fields of a column in one table that are not in a column in another table

2013-10-17 Thread Noel Frankinet
oups, sorry ! On 17 October 2013 16:36, Noel Frankinet noel.franki...@gmail.com wrote: L'accesoire indispensable : http://www.adafruit.com/products/1533 On 17 October 2013 16:29, dean gwilliam mgbg25...@blueyonder.co.ukwrote: On 17/10/2013 14:45, Igor Tandetnik wrote: On 10/17/2013

[sqlite] select all fields of a column in one table that are not in a column in another table

2013-10-16 Thread dean gwilliam
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 names contains no duplicates. I ask because I want to

Re: [sqlite] select all fields of a column in one table that are not in a column in another table

2013-10-16 Thread Igor Tandetnik
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 names contains no duplicates.