Re: [GENERAL] NOT IN vs. OUTER JOIN and NOT NULL

2010-09-09 Thread Alban Hertroys
On 9 Sep 2010, at 13:59, Martín Marqués wrote: > I was looking at rows in a table which are not referenced from another > and found some discrepencies. > > These are the queries (with results): > > SELECT * from grupo_concursantes where codigo NOT IN (SELECT grupo > FROM concursantes); > codigo

Re: [GENERAL] NOT IN vs. OUTER JOIN and NOT NULL

2010-09-09 Thread Thom Brown
2010/9/9 Martín Marqués : > I was looking at rows in a table which are not referenced from another > and found some discrepencies. > > These are the queries (with results): > > SELECT * from grupo_concursantes where codigo NOT IN (SELECT grupo > FROM concursantes); >  codigo | numero | evento | esc

[GENERAL] NOT IN vs. OUTER JOIN and NOT NULL

2010-09-09 Thread Martín Marqués
I was looking at rows in a table which are not referenced from another and found some discrepencies. These are the queries (with results): SELECT * from grupo_concursantes where codigo NOT IN (SELECT grupo FROM concursantes); codigo | numero | evento | escuela +++