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

[Mark Harrison]

Richard Huxton wrote:

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

Ahh, just what I was looking for...

Thanks All!
Mark

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org