Re: [sqlite] Simple Outer Join question?

2009-05-26 Thread Igor Tandetnik
"Leo Freitag" wrote in message news:4a1b9eb9.8070...@netcologne.de > Where do I find a tutorial that deals with 'IN', 'NOT IN' and > subquerys in general? http://www.w3schools.com/sql/default.asp Igor Tandetnik ___ sqlite-users mailing list sqlite-

Re: [sqlite] Simple Outer Join question?

2009-05-26 Thread Leo Freitag
Hi Igor, thanks, works fine! Where do I find a tutorial that deals with 'IN', 'NOT IN' and subquerys in general? Leo Igor Tandetnik schrieb: > "Kees Nuyt" wrote in > message news:8u3m151rqbbel40ilsvaatqmfhcnhsj...@dim53.demon.nl > >> On Mon, 25 May 2009 23:14:50 +0200, Leo Freitag >> wrote

Re: [sqlite] Simple Outer Join question?

2009-05-25 Thread Igor Tandetnik
"Kees Nuyt" wrote in message news:8u3m151rqbbel40ilsvaatqmfhcnhsj...@dim53.demon.nl > On Mon, 25 May 2009 23:14:50 +0200, Leo Freitag > wrote: >> I have a table 'person' and a table 'group'. Every person can join >> none, one or more groups. >> No I want to select all persons except those who are

Re: [sqlite] Simple Outer Join question?

2009-05-25 Thread Kees Nuyt
On Mon, 25 May 2009 23:14:50 +0200, Leo Freitag wrote: >Hallo, > >I have a table 'person' and a table 'group'. Every person can join none, >one or more groups. >No I want to select all persons except those who are member in group 1. >- Sounds simple, but not for me. This is an n:m relationship

[sqlite] Simple Outer Join question?

2009-05-25 Thread Leo Freitag
Hallo, I have a table 'person' and a table 'group'. Every person can join none, one or more groups. No I want to select all persons except those who are member in group 1. - Sounds simple, but not for me. Thanks in advance Leo ___ sqlite-users mail