Re: right join problem

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: Greenhorn <user(dot)postgresql(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: right join problem
Date: 2009-10-02 06:36:06
Message-ID: 20091002063606.GC22496@a-kretschmer.de
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

In response to Greenhorn :
> >
> > Use a left join instead?
> Hi,
> Yes, but when i use a where clause on my query it only selects joined
> records. :(
> Thanks.

Please, answer to the list and not directly to me.

The WHERE-Clause works after the JOIN - so your select contains (without
the WHERE) all rows.

Maybe i don't understand you, can you show a simple example with data?

Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas 2009-10-02 12:47:03 Re: Need magic for a moving statistic
Previous Message A. Kretschmer 2009-10-02 05:45:49 Re: right join problem