Received: from all.all.ee (puu.all.ee [194.204.49.113])
	by hub.org (8.10.1/8.10.1) with ESMTP id e64CFLS80431
	for <pgsql-sql@postgresql.org>; Tue, 4 Jul 2000 08:15:22 -0400 (EDT)
Received: from localhost (localhost [127.0.0.1])
	by all.all.ee (8.9.3/8.9.3) with ESMTP id PAA28154
	for <pgsql-sql@postgresql.org>; Tue, 4 Jul 2000 15:15:14 +0300
Date: Tue, 4 Jul 2000 15:15:14 +0300 (EEST)
From: Antti Linno <alligator@all.ee>
To: pgsql-sql@postgresql.org
Subject: LEFT JOIN 
Message-ID: <Pine.LNX.4.04.10007041506580.27952-100000@all.ee>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Archive-Number: 200007/21

Greetings.
 I have a problem. I have 2 tables. E.g. work and workers. I want to
select records, that 1st table has, and the second hasn't(both have id
attribute). I mean I can't do it with is NULL, because those records don't
exist. I was shown, how it is done with mysql

select first.id,second.id_first 
from first left join second on
id=id_first where id_first is NULL;

but when I tried it in psql, it said, not implemented.

Antti