Received: from srcso.globis.ru (globis.ru [212.248.80.7]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eANFN8A58740 for ; Thu, 23 Nov 2000 10:23:09 -0500 (EST) (envelope-from igor@raduga.dyndns.org) Received: from raduga.dyndns.org (raduga.sochi.net [212.248.82.76]) by srcso.globis.ru (8.9.3/8.9.3) with ESMTP id SAA67731 for ; Thu, 23 Nov 2000 18:50:08 +0300 (MSK) (envelope-from igor@raduga.dyndns.org) Received: (from igor@localhost) by raduga.dyndns.org (8.10.1/8.10.0) id eANFN1H07618 for pgsql-general@postgresql.org; Thu, 23 Nov 2000 18:23:01 +0300 Date: Thu, 23 Nov 2000 18:23:01 +0300 From: "Igor' Robul'" To: Pgsql Mailing List Subject: SQL question Message-ID: <20001123182301.A7557@linux.rainbow> Reply-To: igorr@crosswinds.net Mail-Followup-To: Pgsql Mailing List Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 1.0pre4i X-Archive-Number: 200011/714 X-Sequence-Number: 843 Hello, For example: SELECT words.id, files.id FROM words,files WHERE w=$1 and host=$2 and name=$3; If words table has $1 and files table has $2 and $3 then I'll get result like id1 id2 ------- 223 235 But if words or files does not have corresponding info then it will return empty relation. Is it possible get something like id1 id2 -------- 234 NULL Thank you for info. -- Igor' Robul', Unix System Administrator & Programmer @ sanatorium "Raduga", Sochi, Russia http://www.brainbench.com/transcript.jsp?pid=304744