From: | Maximilian Tyrtania <Mty(at)Fischerappelt(dot)de> |
---|---|
To: | pgsql-novice-Regel <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: outer join question |
Date: | 2004-01-05 17:04:58 |
Message-ID: | BC1F57CA.2393B%Mty@Fischerappelt.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Oops,
Please forget about this, the mail wasn't finished yet.
Sorry,
-> Maximilian Tyrtania | Mty(at)fischerAppelt(dot)de
fischerAppelt Kommunikation GmbH
Tucholskystr. 18 | D-10117 Berlin | Germany
Tel. ++49-30-726146-728 | Fax ++49-30-726146-710
www.fischerAppelt.de
--
> Von: Maximilian Tyrtania <Mty(at)Fischerappelt(dot)de>
> Datum: Mon, 05 Jan 2004 11:20:01 +0100
> An: <pgsql-novice(at)postgresql(dot)org>
> Betreff: outer join question
>
> Folks,
>
> I'm using Openbase and in general I'm quite happy with it, but lately some
> strange behaviour with outer joins have made me look at alternatives.
>
> I basically wnat to know how Postgresql handles the following situation:
>
> Scenario:
> a company table, a people table and a field company_id in the people table.
> Nothing too exotic so far.
>
> Select people.firstname, people.lastname, company.name from people,company
> where people.company_id=company.company_id
>
> -> Maximilian Tyrtania | Mty(at)fischerAppelt(dot)de
> fischerAppelt Kommunikation GmbH
> Tucholskystr. 18 | D-10117 Berlin | Germany
> Tel. ++49-30-726146-728 | Fax ++49-30-726146-710
> www.fischerAppelt.de
> --
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas | 2004-01-05 18:08:00 | Re: postgresql in windows |
Previous Message | gavaneh | 2004-01-05 11:01:24 | postgresql in windows |