Received: from smtp018.mail.yahoo.com (smtp018.mail.yahoo.com [216.136.174.115]) by postgresql.org (8.11.3/8.11.4) with SMTP id f99GJxn13641 for ; Tue, 9 Oct 2001 12:19:59 -0400 (EDT) (envelope-from acroyear_07030@yahoo.com) Received: from adsl-63-202-90-253.dsl.snfc21.pacbell.net (HELO Steph1) (63.202.90.253) by smtp.mail.vip.sc5.yahoo.com with SMTP; 9 Oct 2001 16:19:58 -0000 X-Apparently-From: Message-ID: <006901c150df$e335d690$014ba8c0@myst.com> From: "Stephan Szabo" To: , References: <20011009112958.074132178C9@tartarus.telenet-ops.be> Subject: Re: Linking against null-fields. Date: Tue, 9 Oct 2001 09:31:34 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Archive-Number: 200110/136 X-Sequence-Number: 5091 > SELECT f.ID, d.NAME FROM FILE f, DRIVER d WHERE (d.ID = f.DRIVER); > > However, the only reason I have this query set up as this is to get the name > of the driver easily, if one is set. > > How can this be helped? Should I just get the driver ID as a field, and then > do a second query on that? I think this might work: select f.ID, d.NAME from FILE f LEFT OUTER JOIN DRIVER d ON (d.ID=f.DRIVER); _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com