Postgres Pro
Downloads
Home   >   mailing lists

Re: left outer join only select newest record - Mailing list pgsql-sql

From Gary Stainburn
Subject Re: left outer join only select newest record
Date
Msg-id 201205240921.43670.gary.stainburn@ringways.co.uk
Whole thread Raw
In response to Re: left outer join only select newest record  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: left outer join only select newest record
Next
From: "Oliveiros d'Azevedo Cristina"
Date:
Subject: Re: left outer join only select newest record