From: Jorge Arenas <jorge.arenas@kamarble.com>
To: pgsql-sql@postgresql.org
Subject: subselect and left join not working?
Date: Sun, 28 Nov 2010 21:38:48 -0800 (PST)
Message-ID: <749730.36457.qm@web113802.mail.gq1.yahoo.com> (raw)
Hi,
I am using postgres 8.4 and I am having problems doing a very simple query:
select zona_id from zonas where zona_id not in (select zona_id from usuarios
where per_id =2)
but I get no records in return.
The problem is that, if I I break down the quey, I get:
select zona_id from zonas
"A"
"B"
"C"
"D"
"E"
"F"
"FCHIH"
"FCOAH"
"DGO"
"T"
"FGTO"
"FGRO"
"FQRO"
"FHGO"
"JAL"
"MOR"
"FPUE"
"FQROO"
"FSLP"
"F VER"
"FYUC"
""
select zona_id from usuarios where per_id =2
"E"
"F"
"FCHIH"
"JAL"
"FPUE"
"F VER"
"C"
"D"
"A"
""
but with
select zona_id from zonas where zona_id not in (select zona_id from usuarios
where per_id =2)
I dont' get records when I am expecting to see this:
"B"
"FCOAH"
"DGO"
"T"
"FGTO"
"FGRO"
"FQRO"
"FHGO"
"MOR"
"FQROO"
"FSLP"
"FYUC"
""
What's wrong? Please help. Any clues?
---
It also does not work a left join on 'zonas'. Some 'zonas' are designated to
some users but in my case is not wroking:
t1
usr zone
1 A
2 C
3 D
t2
zone
A
B
C
D
E
I want to see
zone usr
A 1
B
C 2
D 3
E
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jorge.arenas@kamarble.com
Subject: Re: subselect and left join not working?
In-Reply-To: <749730.36457.qm@web113802.mail.gq1.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox