X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 378A14758E6
	for <pgsql-sql@postgresql.org>; Thu, 13 Feb 2003 03:52:28 -0500 (EST)
Received: from filter.mimos.my (filter.mimos.my [192.228.137.70])
	by postgresql.org (Postfix) with ESMTP id B6FF94758C9
	for <pgsql-sql@postgresql.org>; Thu, 13 Feb 2003 03:52:26 -0500 (EST)
Received: from ew.mimos.my (localhost.localdomain [127.0.0.1])
	by filter.mimos.my (8.11.6/8.11.6) with ESMTP id h1D8eMV02643
	for <pgsql-sql@postgresql.org>; Thu, 13 Feb 2003 16:40:22 +0800
Received: (from root@localhost)
	by ew.mimos.my (8.12.3/8.12.3) id h1D8qPB1013131
	for pgsql-sql@postgresql.org; Thu, 13 Feb 2003 16:52:25 +0800 (MYT)
	(envelope-from wahab@mimos.my)
Received: from mimos.my (sol-wel197.nat.mimos.my [10.1.23.197])
	by ew.mimos.my (8.12.3/8.11.6) with ESMTP id h1D8qO1t013035
	for <pgsql-sql@postgresql.org>; Thu, 13 Feb 2003 16:52:24 +0800 (MYT)
	(envelope-from wahab@mimos.my)
Message-ID: <3E4B5CC3.2C10E63A@mimos.my>
Date: Thu, 13 Feb 2003 16:52:19 +0800
From: Abdul Wahab Dahalan <wahab@mimos.my>
Reply-To: wahab@mimos.my
Organization: Mimos Berhad
X-Mailer: Mozilla 4.77 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: UNION or UNION ALL
X-scanner: scanned by Inflex 1.0.10 - (http://pldaniels.com/inflex/)
Content-Type: multipart/alternative;
	boundary="------------BD030C9DBC2828A42A9D040C"
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/278
X-Sequence-Number: 11676

--------------BD030C9DBC2828A42A9D040C
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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

--------------BD030C9DBC2828A42A9D040C
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
I've 3 tables A,B,C
<br>records in table A like:
<br><u>id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; name</u>
<br>b1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; abc
<br>b2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; xyz
<br>b3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rst
<p>records in table B like:
<br><u>id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; type</u>
<br>b1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; logistics
<br>b1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; importer
<br>b2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; logistics
<br>b3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; logistics
<br>b3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; exporter
<p>records in table C like:
<br><u>id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; offer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
title</u>
<br>b1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sell&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
car
<br>b1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; buy&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
car
<br>b1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sell&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
van
<br>b2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sell&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
car
<p>How shoul I do a query so that I can get a result like
<br>(The query will be based on B.type ='logistics')
<br><u>id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
offer</u>
<br>b1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; abc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
sell
<br>b1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; abc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
buy
<br>b1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; abc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
sell
<br>b2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; xyz&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
sell
<br>b3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rst&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
--
<p>Any help very much appricated</html>

--------------BD030C9DBC2828A42A9D040C--