Re: left outer join only select newest record

From: Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: left outer join only select newest record
Date: 2012-05-24 08:21:43
Message-ID: 201205240921.43670.gary.stainburn@ringways.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thursday 24 May 2012 09:17:00 Pavel Stehule wrote:
> please, WHERE (ud_id, ud_pex_registration) = (SELECT ...
>
> replace by
>
> WHERE (..) IN (SELECT ..
>
> Regards
>
> Pavel

Worked perfectly, thank you

--
Gary Stainburn
Group I.T. Manager
Ringways Garages
http://www.ringways.co.uk

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Oliveiros d'Azevedo Cristina 2012-05-24 08:27:56 Re: left outer join only select newest record
Previous Message Pavel Stehule 2012-05-24 08:17:00 Re: left outer join only select newest record