From: Tomasz Myrta <jasiek@klaster.net>
To: wahab@mimos.my
Cc: pgsql-sql@postgresql.org
Subject: Re: UNION or UNION ALL
Date: Thu, 13 Feb 2003 13:04:48 +0100
Message-ID: <3E4B89E0.2060206@klaster.net> (raw)
References: <3E4B5CC3.2C10E63A@mimos.my>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jasiek@klaster.net, wahab@mimos.my
Subject: Re: UNION or UNION ALL
In-Reply-To: <3E4B89E0.2060206@klaster.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox