Re: outer join question

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
> --
>