Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 1FF8A1337B4F
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon, 29 Nov 2010 01:45:41 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 50095-03 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon, 29 Nov 2010 05:45:34 +0000 (UTC)
X-Greylist: delayed 00:06:43.219865 by SQLgrey-1.7.6
Received: from nm11.bullet.mail.sp2.yahoo.com (nm11.bullet.mail.sp2.yahoo.com
	[98.139.91.81])
	by mail.postgresql.org (Postfix) with SMTP id 8DA8D1337B43
	for <pgsql-sql@postgresql.org>; Mon, 29 Nov 2010 01:45:33 -0400 (AST)
Received: from [98.139.91.63] by nm11.bullet.mail.sp2.yahoo.com with NNFMP;
	29 Nov 2010 05:38:49 -0000
Received: from [98.139.91.59] by tm3.bullet.mail.sp2.yahoo.com with NNFMP;
	29 Nov 2010 05:38:49 -0000
Received: from [127.0.0.1] by omp1059.mail.sp2.yahoo.com with NNFMP;
	29 Nov 2010 05:38:49 -0000
X-Yahoo-Newman-Property: ymail-3
X-Yahoo-Newman-Id: 142526.56849.bm@omp1059.mail.sp2.yahoo.com
Received: (qmail 37480 invoked by uid 60001); 29 Nov 2010 05:38:48 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024;
	t=1291009128; bh=eC6xEwN3sLJj78DrSD6Jcxl3yg47H6dB2P6AuNs80gY=;
	h=Message-ID:X-YMail-OSG:Received:X-RocketYMMF:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type;
	b=3vdCueVWhj2j5jnZkDxzLf0gBoSOtiHM3he25xv+BLJ7zw7JL/6dm9cfygKSRSXk++QnXW/IRNaIgvK70JcCHbM+VKd04s0ARf0b+AngyvsRM0dZVrQKZSJq5Jr7fmcbfkp+wQzsLjPDL87Um9FMczfyUa6enJ89mTv1sDErX4w=
Message-ID: <749730.36457.qm@web113802.mail.gq1.yahoo.com>
X-YMail-OSG: jZI43n0VM1kTtfo2orviKxkgvO8tvi9wFSlol.p8Px5rH4o
	mHEZWiQ.uVtndPAK6vtrUmnMO8iioZ.OQ2BkpGhVlF9915LJyfwObqTfVIaB
	1Q8icBPmi4vivigecXplx8VFyDyydF4p2J9gyOCIO.uY3OrpsCTFnd1Yxmr7
	hVuLHiGPbYZAWQ56gCWsnxIPPToI4LSIwEqdmvSTyxg5pANsFZxxycLdBb0q
	gYFwfgdRgh2SuUond0bl60j7wlLb.h1TJ.uWKMHMKYsFmlZdbVhmVZKB9u0k
	0Rj8VhqKl1eDmuXMUioZsswcDE2KhCu4rFbBCJ8dQ9ZEohkpt12Yk.WbRVfF 1yA6w
Received: from [99.16.198.177] by web113802.mail.gq1.yahoo.com via HTTP;
	Sun, 28 Nov 2010 21:38:48 PST
X-RocketYMMF: jleviaguirre
X-Mailer: YahooMailRC/553 YahooMailWebService/0.8.107.285259
Date: Sun, 28 Nov 2010 21:38:48 -0800 (PST)
From: Jorge Arenas <jorge.arenas@kamarble.com>
Subject: subselect and left join not working?
To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-558874469-1291009128=:36457"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=2.467 tagged_above=-5 required=5 tests=BAYES_50=0.8,
	HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001,
	SARE_SPEC_LEO_LINE04=1.666
X-Spam-Level: **
X-Archive-Number: 201011/79
X-Sequence-Number: 34817

--0-558874469-1291009128=:36457
Content-Type: text/plain; charset=us-ascii

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

--0-558874469-1291009128=:36457
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial,helvetica,sans-serif;font-size:10pt;color:#000000;"><div style="font-family: Courier New,courier,monaco,monospace,sans-serif;">Hi, <br><br>I am using postgres 8.4 and I am having problems doing a very simple query:<br><br>select zona_id from zonas where zona_id not in (select zona_id from usuarios where per_id =2)<br>
<br>
but I get no records in return. <br><br>The problem is that, if I I break down the quey, I get:<br><br>select zona_id from zonas <br><br>"A"<br>"B"<br>"C"<br>"D"<br>"E"<br>"F"<br>"FCHIH"<br>"FCOAH"<br>"DGO"<br>"T"<br>"FGTO"<br>"FGRO"<br>"FQRO"<br>"FHGO"<br>"JAL"<br>"MOR"<br>"FPUE"<br>"FQROO"<br>"FSLP"<br>"F VER"<br>"FYUC"<br>""<br><br>select zona_id from usuarios where per_id =2<br><br>"E"<br>"F"<br>"FCHIH"<br>"JAL"<br>"FPUE"<br>"F VER"<br>"C"<br>"D"<br>"A"<br>""<br><br>but with <br><br>select zona_id from zonas where zona_id not in (select zona_id from usuarios where per_id =2)<br>

<br>I dont' get records when I am expecting to see this:<br>
<br>
"B"<br>

"FCOAH"<br>

"DGO"<br>

"T"<br>

"FGTO"<br>

"FGRO"<br>

"FQRO"<br>

"FHGO"<br>

"MOR"<br>

"FQROO"<br>

"FSLP"<br>

"FYUC"<br>

""<br>
<br>What's wrong? Please help. Any clues?<br><br><br>---<br>It also does not work a left join on 'zonas'. Some 'zonas' are designated to some users but in my case is not wroking:<br><br>t1<br>usr&nbsp;&nbsp;&nbsp; zone<br>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A<br>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C<br>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; D<br><br>t2<br>zone<br>A<br>B<br>C<br>D<br>E<br><br>I want to see<br>zone&nbsp;&nbsp;&nbsp; usr<br>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1<br>B<br>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2<br>D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3<br>E<br></div>
</div></body></html>
--0-558874469-1291009128=:36457--