Antw: Problems with joining two tables - Mailing list pgsql-sql

From Gerhard Dieringer
Subject Antw: Problems with joining two tables
Date
Msg-id s8fec883.010@kopo001
Whole thread Raw
List pgsql-sql
Michael Rudolph wrote:

> 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
tablehas a reference to the second table. > I now want to make a query to get all information of the first table and,
ifthere is a reference, the corresponding information of the second table in that row. In > another programming
languageI would just make an if-clause but how can I do this in SQL?
 

What you need is an outer join but as PostgreSQL doesn't support outer joins now (7.0.0), you can simulate it with a
unionas explained in Bruce Momjian book:
 

SELECT name, order_id
FROM customer, salesorder
WHERE customer.customer_id = salesorder.customer_id
UNION ALL
SELECT name, NULL
FROM customer
WHERE customer.customer_id NOT IN (SELECT customer_id FROM salesorder)
ORDER BY name

I hope this will help you.

Gerhard




pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: TOAST (was: BLOB)
Next
From: zoltan.sebestyen@netvisor.hu
Date:
Subject: RE: Check this