Message-ID: <3E4B89E0.2060206@klaster.net>
Date: Thu, 13 Feb 2003 13:04:48 +0100
From: Tomasz Myrta <jasiek@klaster.net>
User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; PL; rv:1.1) Gecko/20020826
MIME-Version: 1.0
To: wahab@mimos.my
Cc: pgsql-sql@postgresql.org
Subject: Re: UNION or UNION ALL
References: <3E4B5CC3.2C10E63A@mimos.my>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Abdul Wahab Dahalan wrote:
 > I've 3 tables A,B,C
 > records in table A like:
 > id          name
 > b1        abc
 > b2        xyz
 > b3        rst
 >
 > records in table B like:
 > id        type
 > b1        logistics
 > b1        importer
 > b2        logistics
 > b3        logistics
 > b3        exporter
 >
 > records in table C like:
 > id        offer        title
 > b1        sell        car
 > b1        buy        car
 > b1        sell        van
 > b2        sell        car
 >
 > How shoul I do a query so that I can get a result like
 > (The query will be based on B.type ='logistics')
 > id        name       offer
 > b1        abc        sell
 > b1        abc        buy
 > b1        abc        sell
 > b2        xyz        sell
 > b3        rst            --
 >
 > Any help very much appricated
select
   id,
   name,
   offer
from
   A
   join B using (_id)
   left join C using (_id)
where type='logistics';

As you see, you don't need any UNION ;-)

BTW - please - turn off HTML format in your mail client.

Regards,
Tomasz Myrta