NOT IN vs. OUTER JOIN and NOT NULL
| От | Martín Marqués |
|---|---|
| Тема | NOT IN vs. OUTER JOIN and NOT NULL |
| Дата | |
| Msg-id | AANLkTink6EN+OwmPwAPZWHb-Ogk22vQS8fJAVPK_JhDm@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: NOT IN vs. OUTER JOIN and NOT NULL
Re: NOT IN vs. OUTER JOIN and NOT NULL |
| Список | pgsql-general |
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
--------+--------+--------+---------
(0 filas)
SELECT g.* FROM grupo_concursantes g left outer join concursantes c on
(g.codigo=c.grupo)
where c.codigo IS NULL;
codigo | numero | evento | escuela
--------+--------+--------+---------
25 | 1 | 1 | 69331
33 | 2 | 1 | 60233
53 | 2 | 1 | 60490
64 | 6 | 1 | 68861
73 | 1 | 1 | 69220
(5 filas)
Why aren't the 5 rows from the second query in the first?
--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador
В списке pgsql-general по дате отправления: