Re: query that needs two nested queries, is this the best

Mark Harrison wrote:
>
> ### QUERY 3:  combine the two statements above by using two subselects
>
> scratch1=# select id from p4_versions where
>            versionof=(select id from p4_files where p4path like
> '%/date.txt')
>            and
>            version=(select headver from p4_files where p4path like
> '%/date.txt');

This won't work if your LIKE matches more than one row anyway.

Try something like:

SELECT id FROM p4_versions WHERE
   (versionof, version) IN (SELECT id,headver FROM p4_files WHERE ...)

--
   Richard Huxton
   Archonet Ltd