Received: from fw1a.telekom.de (gw1.telekom.de [194.25.15.11]) by hub.org (8.9.3/8.9.3) with SMTP id FAA55591 for ; Wed, 19 Apr 2000 05:24:15 -0400 (EDT) (envelope-from Michael.Rudolph@telekom.de) Received: by fw1a.telekom.de; (5.65v4.0/1.3/10May95) id AA05420; Wed, 19 Apr 2000 11:24:11 +0200 Received: from G8PXB.blf01.telekom.de by U8PW4.blf01.telekom.de with ESMTP for pgsql-sql@postgresql.org; Wed, 19 Apr 2000 11:23:58 +0200 Received: from u8p10.blf01.telekom.de by G8PXB.blf01.telekom.de with ESMTP; Wed, 19 Apr 2000 11:17:29 +0200 Received: by U8P10.blf01.telekom.de with Internet Mail Service (5.5.2650.21) id ; Wed, 19 Apr 2000 11:17:28 +0200 Message-Id: From: "Rudolph, Michael" To: "'pgsql-sql@postgresql.org'" Subject: Problems with joining two tables Date: Wed, 19 Apr 2000 11:17:26 +0200 Mime-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) Content-Type: text/plain; charset="iso-8859-1" X-Archive-Number: 200004/198 Hi, I have two tables, the first one has one column as a reference to the index of the second. Not every row in the first table has a reference to the second table. I now want to make a query to get all information of the first table and, if there is a reference, the corresponding information of the second table in that row. In another programming language I would just make an if-clause but how can I do this in SQL? Thanks for your help Michael